ConnorBritain/mssql-mcp-writer
If you are the rightful owner of mssql-mcp-writer 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.
MSSQL MCP Writer is a Model Context Protocol server designed for Microsoft SQL Server, providing data manipulation capabilities with safeguards to prevent schema changes.
Tools
Functions exposed to the LLM to take actions
search_schema
Tool for searching database schema.
describe_table
Provides detailed information about a specific table.
list_table
Lists all tables in the database.
list_databases
Lists all available databases.
list_environments
Lists all configured environments.
profile_table
Profiles a table to provide insights into its structure and data.
inspect_relationships
Inspects relationships between tables.
inspect_dependencies
Inspects dependencies of a table or view.
explain_query
Explains the execution plan of a query.
read_data
Performs SELECT operations to read data.
insert_data
Inserts new data into a table with preview/confirm.
update_data
Updates existing data with preview/confirm.
delete_data
Deletes data with preview/confirm.
list_scripts
Lists all available scripts.
run_script
Executes a specified script.
test_connection
Tests the connection to the database.
validate_environment_config
Validates the environment configuration.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client