sammuka/NewSQL-Server-MCP
If you are the rightful owner of NewSQL-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 dayong@mcphub.com.
The Model Context Protocol (MCP) Server for SQL Server is a robust and secure server designed to provide controlled access to SQL Server databases through specialized tools.
Tools
Functions exposed to the LLM to take actions
list_tables
Lists tables in the database
describe_table
Provides detailed structure of a table
list_columns
Lists columns of a table
list_indexes
Lists indexes of a table
list_views
Lists views in the database
list_procedures
Lists stored procedures
list_functions
Lists functions in the database
execute_select
Executes a SELECT query with validation
get_table_data
Retrieves paginated data from a table
get_database_schema
Retrieves the complete database schema
check_constraints
Checks constraints of a table
execute_query
Executes any SQL query
create_table
Creates a new table
create_index
Creates a new index
insert_data
Inserts data into a table
update_data
Updates records in a table
delete_data
Deletes records from a table
backup_table
Backs up a table
restore_table
Restores a table from backup
create_procedure
Creates a stored procedure
execute_procedure
Executes a stored procedure
manage_users
Manages database users
database_maintenance
Performs database maintenance tasks
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client