Which integrations are available for this server?

Integrates with Google embedding models to facilitate the creation and semantic searching of MindsDB knowledge bases. Allows connecting external MongoDB instances as data sources within MindsDB for data integration and querying. Uses the MySQL protocol to interface with MindsDB and enables connecting external MySQL databases as data sources for SQL query execution. Integrates with Ollama embedding models to facilitate the creation and semantic searching of MindsDB knowledge bases. Integrates with OpenAI embedding models to facilitate the creation and semantic searching of MindsDB knowledge bases.

How do I use MindsDB MySQL MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MindsDB MySQL MCP Server search the documentation knowledge base for 'how to configure authentication'" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

MindsDB MySQL MCP Server

MCP server for MindsDB that connects via MySQL protocol (port 47335), providing reliable tools for Claude Code and Desktop.

Why MySQL over SSE/HTTP?

MySQL protocol is stable and well-tested
No async event loop issues (the "this event loop is already running" errors)
Better error messages and debugging
Works reliably with knowledge base queries

Installation

cd mcp/mindsdb-mysql npm install npm run build

Configuration

Environment Variables

Variable	Default	Description
`MINDSDB_HOST`	`127.0.0.1`	MindsDB server host
`MINDSDB_PORT`	`47335`	MindsDB MySQL port
`MINDSDB_USER`	`mindsdb`	Username (use your MindsDB Cloud email for cloud instances)
`MINDSDB_PASSWORD`	(empty)	Password (required for MindsDB Cloud)

Claude Code (`~/.claude.json`)

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

For MindsDB Cloud, use your email as MINDSDB_USER and your password for MINDSDB_PASSWORD.

Claude Desktop (`claude_desktop_config.json`)

Same configuration, add to the mcpServers object.

Available Tools (11)

1. `query` - Execute SQL

Execute any MindsDB SQL query. Use this for custom queries not covered by other tools.

query(sql: string, database?: string): QueryResult

2. `list_databases` - List Data Sources

List all databases/data sources in MindsDB.

list_databases(): string[]

3. `list_knowledge_bases` - List KBs

List all knowledge bases in MindsDB.

list_knowledge_bases(): KnowledgeBase[]

4. `describe` - Describe Any Object

Describe a model, table, or knowledge base. Returns column information.

describe(name: string, database?: string): Description

5. `search_kb` - Search Knowledge Base

Search a knowledge base using hybrid semantic + keyword search.

search_kb( kb_name: string, question: string, limit?: number, // default: 10 alpha?: number, // default: 0.5 (0=keyword, 1=semantic) min_relevance?: number, // default: 0 metadata_filter?: Record<string, string> ): SearchResult[]

6. `insert_kb` - Insert Data into Knowledge Base

Insert data into a knowledge base from a source query.

insert_kb( kb_name: string, source_query: string, // e.g., "SELECT id, content FROM mydb.docs" batch_size?: number, // default: 1000 threads?: number, // default: 1 skip_existing?: boolean // default: false ): { rows_inserted: number }

7. `create_kb` - Create Knowledge Base

Create a new knowledge base with embedding model configuration.

create_kb( name: string, embedding_model: { provider: string, // openai, azure, google, ollama model_name: string, api_key?: string }, content_columns: string[], metadata_columns?: string[], id_column?: string, reranking_model?: {...}, storage?: string // default: chromadb ): { kb_name: string }

8. `list_jobs` - List Scheduled Jobs

List all scheduled jobs in MindsDB.

list_jobs(): Job[]

9. `create_job` - Schedule Recurring Query

Create a scheduled job to run a query at regular intervals.

create_job( name: string, query: string, // SQL to execute every: string, // e.g., "1 hour", "1 day" start?: string, // ISO datetime end?: string // ISO datetime ): { job_name: string }

10. `list_tables` - List Tables

List all tables in a specific database.

list_tables(database: string): string[]

11. `connect_database` - Connect External Data Source

Connect an external database as a data source in MindsDB.

connect_database( name: string, engine: string, // postgres, mysql, mongodb, etc. parameters: { host: string, port: number, database: string, user: string, password: string } ): { database_name: string }

Testing

With MCP Inspector

npx @modelcontextprotocol/inspector node dist/index.js

Or with a remote MindsDB instance:

MINDSDB_HOST=your-mindsdb-host MINDSDB_PORT=47335 \ npx @modelcontextprotocol/inspector node dist/index.js

Manual verification

After configuring Claude Code, restart and verify:

# In Claude Code, these tools should be available: mcp__mindsdb__list_databases mcp__mindsdb__list_knowledge_bases mcp__mindsdb__search_kb mcp__mindsdb__query # ... etc.

MindsDB SQL Reference

Knowledge Base Query

-- Semantic search SELECT * FROM my_kb WHERE content = 'search phrase' LIMIT 10; -- With relevance filter SELECT * FROM my_kb WHERE content = 'query' AND relevance >= 0.5; -- Hybrid search (keyword + semantic) SELECT * FROM my_kb WHERE content = 'query' AND hybrid_search_alpha = 0.8; -- Metadata filter SELECT * FROM my_kb WHERE content = 'query' AND metadata_column = 'value';

Output Columns

chunk_id: <id>:<chunk_number>of<total>:<start_char>to<end_char>
chunk_content: The text content
relevance: 0-1 score (higher = better match)
distance: Vector distance (lower = closer)

MindsDB MySQL MCP Server

MindsDB MySQL MCP Server

Why MySQL over SSE/HTTP?

Installation

Configuration

Environment Variables

Claude Code (`~/.claude.json`)

Claude Desktop (`claude_desktop_config.json`)

Available Tools (11)

1. `query` - Execute SQL

2. `list_databases` - List Data Sources

3. `list_knowledge_bases` - List KBs

4. `describe` - Describe Any Object

5. `search_kb` - Search Knowledge Base

6. `insert_kb` - Insert Data into Knowledge Base

7. `create_kb` - Create Knowledge Base

8. `list_jobs` - List Scheduled Jobs

9. `create_job` - Schedule Recurring Query

10. `list_tables` - List Tables

11. `connect_database` - Connect External Data Source

Testing

With MCP Inspector

Manual verification

MindsDB SQL Reference

Knowledge Base Query

Output Columns

Resources

Tools

New MCP Servers

Latest Blog Posts

MCP directory API

MindsDB MySQL MCP Server

Why MySQL over SSE/HTTP?

Installation

Configuration

Environment Variables

Claude Code (~/.claude.json)

Claude Desktop (claude_desktop_config.json)

Available Tools (11)

1. query - Execute SQL

2. list_databases - List Data Sources

3. list_knowledge_bases - List KBs

4. describe - Describe Any Object

5. search_kb - Search Knowledge Base

6. insert_kb - Insert Data into Knowledge Base

7. create_kb - Create Knowledge Base

8. list_jobs - List Scheduled Jobs

9. create_job - Schedule Recurring Query

10. list_tables - List Tables

11. connect_database - Connect External Data Source

Testing

With MCP Inspector

Manual verification

MindsDB SQL Reference

Knowledge Base Query

Output Columns

Resources

Tools

New MCP Servers

Latest Blog Posts

MCP directory API

Claude Code (`~/.claude.json`)

Claude Desktop (`claude_desktop_config.json`)

1. `query` - Execute SQL

2. `list_databases` - List Data Sources

3. `list_knowledge_bases` - List KBs

4. `describe` - Describe Any Object

5. `search_kb` - Search Knowledge Base

6. `insert_kb` - Insert Data into Knowledge Base

7. `create_kb` - Create Knowledge Base

8. `list_jobs` - List Scheduled Jobs

9. `create_job` - Schedule Recurring Query

10. `list_tables` - List Tables

11. `connect_database` - Connect External Data Source