mcp-sql-server

umairahmed786/mcp-sql-server

3.2

If you are the rightful owner of mcp-sql-server 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.

MCP SQL Server is a lightweight server that connects to a MySQL database and exposes its schema and query capabilities to LLM-based tools.

Tools

Functions exposed to the LLM to take actions

list_tables

Lists all tables in the connected database

get_table_schema

Retrieves schema for a specific table

get_database_schema

Returns a full schema overview with columns, keys, and relationships

run_query

Executes read-only SELECT queries

explain_query

Returns the MySQL EXPLAIN plan for a given query

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources