MCP-DbServer

DashrathYadav/MCP-DbServer

3.1

If you are the rightful owner of MCP-DbServer and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

MsDbServer is a Model Context Protocol (MCP) server designed to facilitate interaction between AI assistants and MySQL databases, enabling natural language queries and database introspection.

Tools

Functions exposed to the LLM to take actions

ListTables

Get all tables in the database.

DescribeTable

Provides detailed table schema with columns, keys, and indexes.

ExecuteQuery

Run SELECT queries safely with limits.

GetDatabaseStats

Provides database size, table counts, and statistics.

GetSchemaInfo

Fetches multiple table schemas with pattern matching.

GetTableRelationships

Displays foreign key dependencies and relationships.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources