MindsDB MySQL

Provides MindsDB data access over the MySQL protocol with tooling for Claude Code and Desktop.

typescript

0

GitHub Stars

typescript

Language

5 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "nikhgupta-mindsdb-mysql-mcp": {
      "command": "node",
      "args": [
        "/path/to/mindsdb-mysql/dist/index.js"
      ],
      "env": {
        "MINDSDB_HOST": "localhost",
        "MINDSDB_PORT": "47335",
        "MINDSDB_USER": "mindsdb"
      }
    }
  }
}

You deploy a MindsDB MCP server that speaks the MySQL protocol on port 47335, enabling Claude Code and Claude Desktop to run MindsDB queries, manage knowledge bases, and interact with data sources through familiar SQL-like commands. This MCP server provides stable connectivity and clear error handling for MindsDB workflows that rely on the MySQL protocol.

How to use

After you configure Claude Code or Claude Desktop to connect to the MindsDB MCP server, you can execute SQL queries, manage databases, knowledge bases, and jobs just like you would with a MySQL-compatible interface. Use the provided tools to perform common tasks such as listing databases, describing objects, searching knowledge bases, inserting data, and running scheduled jobs.

Key usage patterns include: extracting data with SQL queries, inspecting MindsDB structures, and performing knowledge-base actions through dedicated MCP tools. For example, you can query data, list databases, and search knowledge bases using the available tools exposed by the MCP server.

To verify your setup, restart Claude Code or Claude Desktop after configuring the MCP server, then ensure the following tools are available in Claude Code: mcp__mindsdb__list_databases, mcp__mindsdb__list_knowledge_bases, mcp__mindsdb__search_kb, mcp__mindsdb__query, and related tooling. You can call these tools with your MindsDB context to perform the corresponding actions.

How to install

Prerequisites: you need Node.js installed on your system. Verify by running node -v and npm -v.

cd mcp/mindsdb-mysql
npm install
npm run build

Available tools

query

Execute a MindsDB SQL query for custom data retrieval and analysis.

list_databases

List all databases or data sources registered in MindsDB.

list_knowledge_bases

List all knowledge bases available in MindsDB.

describe

Describe an object such as a model, table, or knowledge base to inspect its schema.

search_kb

Search a knowledge base using a hybrid semantic + keyword approach with optional relevance filters.

insert_kb

Insert data into a knowledge base from a source query.

create_kb

Create a new knowledge base with embedding model configuration and content columns.

list_jobs

List all scheduled jobs in MindsDB.

create_job

Schedule a recurring query to run at defined intervals.

list_tables

List all tables in a specific database.

connect_database

Connect an external data source as a MindsDB data source.