MindsDB MySQL MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MINDSDB_HOST | No | MindsDB server host | 127.0.0.1 |
| MINDSDB_PORT | No | MindsDB MySQL port | 47335 |
| MINDSDB_USER | No | Username (use your MindsDB Cloud email for cloud instances) | mindsdb |
| MINDSDB_PASSWORD | No | Password (required for MindsDB Cloud) |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| queryB | Execute any MindsDB SQL query. Use this for custom queries not covered by other tools. |
| list_databasesB | List all databases/data sources in MindsDB. |
| list_knowledge_basesB | List all knowledge bases in MindsDB. |
| describeC | Describe a model, table, or knowledge base. Returns column information and structure. |
| search_kbA | Search a knowledge base using hybrid semantic + keyword search. Returns relevant chunks with relevance scores. |
| insert_kbC | Insert data into a knowledge base from a source query. Supports batch processing. |
| create_kbC | Create a new knowledge base with embedding model configuration. |
| list_jobsB | List all scheduled jobs in MindsDB. |
| create_jobC | Create a scheduled job to run a query at regular intervals. |
| list_tablesC | List all tables in a specific database. |
| connect_databaseC | Connect an external database as a data source in MindsDB. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 11 tools
Most tools have distinct purposes, such as connect_database for data source connections and search_kb for hybrid searches. However, the 'describe' tool is somewhat ambiguous as it can describe models, tables, or knowledge bases, potentially overlapping with other tools like list_tables or list_knowledge_bases in providing structural information, which could cause minor confusion.
All tool names follow a consistent verb_noun pattern using snake_case, such as connect_database, create_job, and list_tables. This uniformity makes the tool set predictable and easy to understand, with no deviations in naming conventions across the 11 tools.
With 11 tools, the server is well-scoped for managing MindsDB's features like databases, jobs, knowledge bases, and queries. Each tool serves a clear purpose, such as list_databases for listing sources and query for custom SQL, making the count appropriate without being overwhelming or insufficient.
The tool set covers key MindsDB operations, including data source management (connect_database, list_databases), knowledge base handling (create_kb, insert_kb, search_kb), and job scheduling (create_job, list_jobs). A minor gap is the lack of update or delete tools for jobs or knowledge bases, but agents can likely work around this using the query tool for custom modifications.