Skip to main content

MindsDB's AI SQL Server enables developers to build AI tools that need access to real-time data to perform their tasks

Project description

Query engine for AI analytics, powering agents to answer questions across all your live data


MindsDB develops the following products:

  • ANTON - A personal AI agent that helps you get work done. Tell it what you need in plain language and it takes it from there - sending emails, calling APIs, connecting to data sources, building dashboards, and delivering results. No setup, no plugins, no fuss.

  • Query Engine - The product you are looking at, is a popular query engine for semantic-search.

What you can build with MindsDB Products

CONVERSATIONAL ANALYTICS AGENTS SEMANTIC SEARCH AGENTS
Get precise, data-driven answers using natural language.

Unify and query data across sources (MySQL, Salesforce, Shopify, etc.), without ETL.

Try Anton
Ground LLM responses in your most relevant internal knowledge.

Search across unstructured sources like documents, support tickets, Google Drive, and more.

Watch video

How MindsDB - Query Engine works

MindsDB - Query Engine follows a simple workflow: Connect → Unify → Respond. At the center is an SQL-compatible data language with additional constructs for searching unstructured data, managing workflows (jobs/triggers), and building agents.

Connect Universal data access: Give your agents federated access to 200+ live data sources (Postgres, MongoDB, Slack, files, and more).
Unify Dynamic context engine: Fuse structured tables with vectorized data (text, PDFs, HTML) inside a Knowledge Base.
Respond Autonomous reasoning: Deploy agents that blend and retrieve data points across your stack to produce grounded answers.

Setup

Users can install MindsDB via Docker, Docker Extension, or PyPI.

Here is how to pull and run MindsDB via Docker:

docker run --name mindsdb_container \
-e MINDSDB_APIS=http,mysql \
-p 47334:47334 -p 47335:47335 \
mindsdb/mindsdb:latest

Usage

Follow the quickstart guide to get started with MindsDB using our demo data.

Retrieve and analyze data from over 200 data sources in one SQL dialect. For AI agents, this means faster response time, better accuracy, and lower token consumption.

--use SQL to aggregate pipeline data from Salesforce 
SELECT SUM(ExpectedRevenue) AS open_pipeline
FROM salesforce.opportunities
WHERE close_date >= CURDATE()

--use the same dialect to retrieve even from a non-SQL database, like MondoDB
SELECT COUNT(*) AS negative_emails_last_30_days
FROM mongodb.support_tickets
WHERE sentiment = 'negative'
  AND created_at >= CURRENT_DATE - INTERVAL '30 days';

Create views and join data even from different types of data systems.

--join MongoDB and Salesforce data
CREATE VIEW risky_renewals AS (
SELECT *
FROM mongodb.support_tickets AS reviews
JOIN salesforce.opportunities AS deals
  ON reviews.customer_domain = deals.customer_domain
WHERE deals.type = "renewal"
  AND reviews.sentiment = "negative"
);

Join vectorized and structured data inside a knowledge base. Combine semantic search with precise metadata criteria in a single SQL query.

--create a knowledge base for customer issues 
CREATE KNOWLEDGE_BASE customers_issues
USING
  storage = my_vector.db,
  content_columns = ['ticket_description'];
  metadata_columns = ['customer_name', 'segment', 'revenue', 'is_pending_renewal'];

--find large customers who submitted ticket related to data security topics  
SELECT * FROM customers_issues
WHERE content = 'data security'
AND
  is_pending_renewal = 'true'.
  revenue > 1000000;

Use MindsDB pre-packaged data agents and connect them with your own. See how to use MindsDB via API or MCP.

CREATE AGENT my_agent
USING
    model = {
        "provider": "openai",
        "model_name" : "gpt-xx",
        "api_key": "sk-..."
    },
    data = {
         "knowledge_bases": ["mindsdb.customer_issues"],
         "tables": ["salesforce.opportunities", "postgres.sales", "mongodb.support_tickets"]
    },
    prompt_template = 'my prompt template and agent guidance';

See MindsDB’s recommended usage of agents here and how to automate workflows with jobs.

📃 Tutorials

  • Enterprise Knowledge Search (example)
  • Advanced Semantic Search (example)
  • Customer Support Automation (example1, example2)
  • Intelligent Content Discovery (example)
  • Financial Analysis Agents (example)
  • Real-time AI-powered analytics (example)
  • Conversational Data Assistants (example)
  • CRM Intelligence (example)
  • Compliance & Customer Intelligence (example)
  • Conversation Intelligence (example) Subscribe to our (blog) for more

🫴 Help and support

Stuck on a query? Found a bug? We’re here to help.

Ask a question Join our Slack Community.
Report a bug Open a GitHub Issue. Please include reproduction steps!
Get commercial support Contact the MindsDB Team for enterprise SLAs and custom solutions.

Security Note: If you find a security vulnerability, please do not open a public issue. Refer to our security policy for reporting instructions.

🤝 Contribute to MindsDB

MindsDB is open source and contributions are welcome! You can submit code changes through pull requests or by opening issues to report bugs, suggest new features, or enhancements.

Ways you can help:

How to contribute

Our top 100 contributors

Made with contrib.rocks

📚 Resources

Project details


Release history Release notifications | RSS feed

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mindsdb-26.1.0rc1.tar.gz (1.0 MB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

mindsdb-26.1.0rc1-py3-none-any.whl (1.2 MB view details)

Uploaded Python 3

File details

Details for the file mindsdb-26.1.0rc1.tar.gz.

File metadata

  • Download URL: mindsdb-26.1.0rc1.tar.gz
  • Upload date:
  • Size: 1.0 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.15

File hashes

Hashes for mindsdb-26.1.0rc1.tar.gz
Algorithm Hash digest
SHA256 bc75a1aef62a26ca0c51bc41e114d14130f691008ced39227f4e0ba3e578b078
MD5 3e7608e412870c81b01d3812a5d21f5a
BLAKE2b-256 ccc6b1760e535bc80d0dd4d6784bcee58bfd3023b3bb0992392f78a97258d30e

See more details on using hashes here.

File details

Details for the file mindsdb-26.1.0rc1-py3-none-any.whl.

File metadata

  • Download URL: mindsdb-26.1.0rc1-py3-none-any.whl
  • Upload date:
  • Size: 1.2 MB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.15

File hashes

Hashes for mindsdb-26.1.0rc1-py3-none-any.whl
Algorithm Hash digest
SHA256 bb411b606d1d6417eba8abc8bd06d7bfe5904dfd1f010dc3d4a224a258edd775
MD5 5d133f12b411e2438b5dd222dc469b2b
BLAKE2b-256 1e6ee9994cf60c562bcd281665d4a9a24840099ddf83ed2e60ea7307606da61f

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page