290design/sql-server-mcp
If you are the rightful owner of sql-server-mcp 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.
The SQL Server MCP Tools provide a Model Context Protocol server for SQL Server schema introspection and database metadata tools, designed for LLM applications like Claude Desktop.
Tools
Functions exposed to the LLM to take actions
get_schema
Batch retrieval of multiple tables' metadata.
get_table_info
Quick lookup for a single table.
find_tables
Search tables by name pattern or column name.
get_relationships
Discover foreign key relationships between tables.
validate_objects
Validate database/schema/table names with fuzzy matching.
find_routines
Search for stored procedures and functions by name pattern.
get_routine_definition
Get complete definition of a stored procedure or function.
get_routines_schema
Batch retrieval of multiple stored procedures/functions.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client