TharanaBope/SQL-MCP-Mac-Windows
If you are the rightful owner of SQL-MCP-Mac-Windows and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
SQL Server MCP is a cross-platform database integration server that allows AI assistants to explore and query SQL Server databases using natural language.
Tools
Functions exposed to the LLM to take actions
list_databases
Discover all available databases.
list_tables
View tables with row counts.
describe_table
Get detailed schema including columns, types, constraints, and indexes.
list_views
List all views.
list_stored_procedures
List stored procedures with metadata.
get_procedure_definition
Get full SQL definition of a procedure.
get_database_overview
Provide high-level statistics of the database.
get_table_relationships
Get foreign key relationships (incoming & outgoing).
get_related_tables
Find directly connected tables.
search_schema
Search across tables, columns, views, and procedures.
find_column_usage
Find all tables containing a specific column.
execute_query
Execute read-only SELECT queries safely.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client