MindsDB Tools

About

MindsDB is the most widely adopted AI federated database that enables you to query hundreds of datasources and ML models through a single SQL interface. The following tools work with MindsDB databases:

• mindsdb-execute-sql - Execute SQL queries directly on MindsDB
• mindsdb-sql - Execute parameterized SQL queries on MindsDB

These tools leverage MindsDB’s capabilities to:

• Connect to Multiple Datasources: Query databases, APIs, file systems, and more through SQL
• Cross-Datasource Operations: Perform joins and analytics across different data sources
• ML Model Integration: Use trained ML models as virtual tables for predictions
• Unstructured Data Processing: Query documents, images, and other unstructured data as structured tables
• Real-time Predictions: Get real-time predictions from ML models through SQL
• API Translation: Automatically translate SQL queries into REST APIs, GraphQL, and native protocols

Supported Datasources

MindsDB automatically translates your SQL queries into the appropriate APIs for hundreds of datasources:

Business Applications

• Salesforce: Query leads, opportunities, accounts, and custom objects
• Jira: Access issues, projects, workflows, and team data
• GitHub: Query repositories, commits, pull requests, and issues
• Slack: Access channels, messages, and team communications
• HubSpot: Query contacts, companies, deals, and marketing data

Databases & Storage

• MongoDB: Query NoSQL collections as structured tables
• PostgreSQL/MySQL: Standard relational databases
• Redis: Key-value stores and caching layers
• Elasticsearch: Search and analytics data
• S3/Google Cloud Storage: File storage and data lakes

Communication & Email

• Gmail/Outlook: Query emails, attachments, and metadata
• Microsoft Teams: Team communications and files
• Discord: Server data and message history

Analytics & Monitoring

• Google Analytics: Website traffic and user behavior
• Mixpanel: Product analytics and user events
• Datadog: Infrastructure monitoring and logs
• Grafana: Time-series data and metrics

Example Use Cases

Cross-Datasource Analytics

-- Join Salesforce opportunities with GitHub activity
SELECT 
    s.opportunity_name,
    s.amount,
    g.repository_name,
    COUNT(g.commits) as commit_count
FROM salesforce.opportunities s
JOIN github.repositories g ON s.account_id = g.owner_id
WHERE s.stage = 'Closed Won';

Email & Communication Analysis

-- Analyze email patterns with Slack activity
SELECT 
    e.sender,
    e.subject,
    s.channel_name,
    COUNT(s.messages) as message_count
FROM gmail.emails e
JOIN slack.messages s ON e.sender = s.user_name
WHERE e.date >= '2024-01-01';

ML Model Predictions

-- Use ML model to predict customer churn
SELECT 
    customer_id,
    customer_name,
    predicted_churn_probability,
    recommended_action
FROM customer_churn_model
WHERE predicted_churn_probability > 0.8;

Since MindsDB implements the MySQL wire protocol, these tools are functionally compatible with MySQL tools while providing access to MindsDB’s advanced federated database capabilities.

Working Configuration Example

Here’s a complete working configuration that has been tested:

sources:
  my-pg-source:
    kind: mindsdb
    host: 127.0.0.1
    port: 47335
    database: files
    user: mindsdb

tools:
  mindsdb-execute-sql:
    kind: mindsdb-execute-sql
    source: my-pg-source
    description: |
      Execute SQL queries directly on MindsDB database.
      Use this tool to run any SQL statement against your MindsDB instance.
      Example: SELECT * FROM my_table LIMIT 10