bilims/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 Model Context Protocol (MCP) server that enables AI agents to interact with Microsoft SQL Server databases through secure, intelligent database operations.
Tools
Functions exposed to the LLM to take actions
sql_test_connection
Database connectivity testing
sql_select
Advanced SELECT queries with filtering and joins
sql_insert
Safe record insertion
sql_update
Conditional record updates
sql_delete
Safe record deletion
sql_query
Custom SELECT statement execution
sql_get_tables
Database table listing
sql_get_columns
Table column information
sql_get_table_structure
Complete table structure analysis
sql_get_schemas
Database schema exploration
sql_execute_stored_procedure
Execute stored procedures with parameters
sql_get_stored_procedures
List all stored procedures
sql_get_stored_procedure_info
Get detailed stored procedure information
sql_begin_transaction
Start database transactions with isolation levels
sql_commit_transaction
Commit active transactions
sql_rollback_transaction
Rollback transactions or to savepoints
sql_create_savepoint
Create transaction savepoints
sql_get_transaction_status
Check current transaction status
sql_bulk_insert
High-performance bulk insert operations
sql_batch_update
Batch update multiple records
sql_batch_delete
Batch delete multiple records
sql_import_data
Import data from CSV/JSON formats
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client