Skip to main content
Glama
nikhgupta

MindsDB MySQL MCP Server

by nikhgupta

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MINDSDB_HOSTNoMindsDB server host127.0.0.1
MINDSDB_PORTNoMindsDB MySQL port47335
MINDSDB_USERNoUsername (use your MindsDB Cloud email for cloud instances)mindsdb
MINDSDB_PASSWORDNoPassword (required for MindsDB Cloud)

Tools

Functions exposed to the LLM to take actions

NameDescription
query

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

list_databases

List all databases/data sources in MindsDB.

list_knowledge_bases

List all knowledge bases in MindsDB.

describe

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

search_kb

Search a knowledge base using hybrid semantic + keyword search. Returns relevant chunks with relevance scores.

insert_kb

Insert data into a knowledge base from a source query. Supports batch processing.

create_kb

Create a new knowledge base with embedding model configuration.

list_jobs

List all scheduled jobs in MindsDB.

create_job

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

list_tables

List all tables in a specific database.

connect_database

Connect an external database as a data source in MindsDB.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/nikhgupta/mindsdb-mysql-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server