vini-cius/mcp-sqlserver
If you are the rightful owner of mcp-sqlserver 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.
A secure and robust Model Context Protocol (MCP) service for executing SQL Server queries through a standardized interface.
Tools
Functions exposed to the LLM to take actions
execute_query
Executes safe SQL queries with parameter support.
get_table_schema
Retrieves detailed column information for a specific table.
list_tables
Lists all tables in the database with optional schema filtering.
get_database_info
Retrieves general database information (name, version, edition, etc.).
list_procedures
Lists all stored procedures in the database, optionally filtered by schema.
list_functions
Lists all functions (scalar and table-valued) in the database, optionally filtered by schema and function type.
get_procedure_schema
Gets the schema and parameters of a specific stored procedure.
get_function_schema
Gets the schema and parameters of a specific function.
execute_procedure
Executes a stored procedure with parameters.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client