MindsDB's MCP Server Usage and Tools

MindsDB is an MCP server that enables your MCP applications to answer questions over large-scale federated data spanning databases, data warehouses, and SaaS applications.

Start MindsDB as an MCP Server

Follow the steps below to use MindsDB as an MCP server.

1. Install MindsDB locally via Docker or Docker Desktop.

2. Connect your data source and/or upload files to MindsDB in order to ask questions over your data.

   Sample Data

   You can use our sample dataset that stores the sales manager data.

   CREATE DATABASE sales_manager_data
   WITH ENGINE = "postgres",
   PARAMETERS = {
       "user": "demo_user",
       "password": "demo_password",
       "host": "samples.mindsdb.com",
       "port": "5432",
       "database": "sales_manager_data"
   };
   

3. Start MindsDB MCP server, either with or without authentication.

   • Start MindsDB MCP server without authentication to connect it to Cursor.

     docker run --name mindsdb_container -p 47334:47334 -p 47335:47335 mindsdb/mindsdb
     

   • Start MindsDB MCP server with authentication to connect it to OpenAI or Anthropic.

     docker run --name mindsdb_container -p 47334:47334 -p 47335:47335 -e MINDSDB_USERNAME=admin -e MINDSDB_PASSWORD=password123 mindsdb/mindsdb
     

     Then get an auth token from MindsDB:

     curl -X POST -d '{"username":"admin","password":"password123"}' -H "Content-Type: application/json" http://localhost:47334/api/login
     

     This will return a token that you can use in your MCP client.

MCP Tools

MindsDB MCP API exposes a set of tools that enable users to interact with their data and extract valuable insights.

1. List Databases

The list_databases tool lists all data sources connected to MindsDB.

2. Query

The query tool executes queries on the federated data to extract data relevant to answering a given question.