What can you do with this server?

The SQL Server MCP Server connects AI agents to SQL Server databases for schema inspection, query execution, data diagnostics, and connection management. * Connection Management: List, switch, add, and remove named database connection profiles dynamically (connections can be configured via JSON file, environment variables, or during a session). * Query Execution: Run SELECT queries immediately (with an optional row limit, default 500). Execute write operations—INSERT, UPDATE, DELETE, DDL (CREATE, ALTER, DROP TABLE, TRUNCATE), and stored procedures—only after a preview step that requires explicit confirmation. * Schema Inspection: List tables with row counts (optionally include views), inspect full table details (columns, data types, keys, indexes), list stored procedures with name filtering, and retrieve their source definitions. * Data Diagnostics: Search for a value across all columns in a table; check foreign key violations (orphaned records) for one or all tables; count rows and sample data with optional filtering; identify rows with NULL values in specified columns; compare row counts between parent and child tables to find data gaps; generate a comprehensive table diagnostic report covering counts, nulls, FK violations, and recent rows. * Performance Analysis: Retrieve the estimated execution plan for any SELECT query. * Safety & Permissions: SELECT queries run without confirmation; any write operation requires a dry-run preview and an explicit confirm: true flag; dangerous operations like DROP DATABASE, xp_cmdshell, and BULK INSERT are permanently blocked.

How do I use SQL Server MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@SQL Server MCP Server List all tables in the database" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

SQL Server MCP Server

by dkp5897

Overview Schema Related Servers Score Discussions

JavaScript

Remote

SQL Server MCP Server

A Model Context Protocol (MCP) server for SQL Server — built for development debugging and multi-database data repair. Connects to Antigravity (the AI agent) so you can inspect schemas, run queries, and diagnose data problems across multiple databases directly from your IDE chat.

🚀 Setup & Configuration

You can configure single or multiple SQL Server databases directly using any of these 3 clean methods:

Method 1: Using a `connections.json` File (Easiest & Cleanest!) 🌟

Create a connections.json file in your workspace directory (or set CONNECTIONS_FILE in env pointing to your JSON file path). Write your database connections in clean JSON array format without any escaping:

[
  {
    "name": "sweet-shop",
    "label": "PradeepSweetShop Dev",
    "server": "localhost\\SQLEXPRESS",
    "database": "PradeepSweetShopDb",
    "user": "sa",
    "password": "your_password"
  },
  {
    "name": "ecommerce",
    "label": "ECommerce Dev",
    "server": "localhost\\SQLEXPRESS",
    "database": "ECommerceDB",
    "user": "sa",
    "password": "your_password"
  }
]

And configure mcp_config.json:

{
  "mcpServers": {
    "sql-server-mcp": {
      "command": "npx",
      "args": ["-y", "@dkcodingcenter/sql-server-mcp"],
      "env": {
        "CONNECTIONS_FILE": "C:/path/to/connections.json"
      }
    }
  }
}

Method 2: Environment Variable (`DB_CONNECTIONS` JSON Array)

Pass a JSON array string directly in DB_CONNECTIONS:

{
  "mcpServers": {
    "sql-server-mcp": {
      "command": "npx",
      "args": ["-y", "@dkcodingcenter/sql-server-mcp"],
      "env": {
        "DB_CONNECTIONS": "[{\"name\":\"sweet-shop\",\"label\":\"PradeepSweetShop Dev\",\"server\":\"localhost\\\\SQLEXPRESS\",\"database\":\"PradeepSweetShopDb\",\"user\":\"sa\",\"password\":\"your_password\"},{\"name\":\"ecommerce\",\"label\":\"ECommerce Dev\",\"server\":\"localhost\\\\SQLEXPRESS\",\"database\":\"ECommerceDB\",\"user\":\"sa\",\"password\":\"your_password\"}]"
      }
    }
  }
}

Method 3: Single Database Configuration

{
  "mcpServers": {
    "sql-server-mcp": {
      "command": "npx",
      "args": ["-y", "@dkcodingcenter/sql-server-mcp"],
      "env": {
        "DB_SERVER": "localhost",
        "DB_NAME": "PradeepSweetShopDb",
        "DB_USER": "sa",
        "DB_PASSWORD": "your_password"
      }
    }
  }
}

Related MCP server: MSSQL MCP Server

🛠️ Available Tools (17 total)

Connection Management

Tool	Description
`sql_list_connections`	List all loaded SQL Server connection profiles and see which one is active
`sql_switch_connection`	Switch default active connection to another loaded profile by name
`sql_add_connection`	Dynamically add or update a named connection profile during chat session
`sql_remove_connection`	Remove a connection profile

Query Execution

Tool	Description
`sql_run_query`	Run a SELECT query (accepts optional `connection` name parameter)
`sql_run_write`	Run INSERT/UPDATE/DELETE/DDL — shows preview first, requires confirm=true to execute

Schema Inspection

Tool	Description
`sql_list_tables`	List all tables with row counts
`sql_inspect_table`	Full table details: columns, PKs, FKs, indexes
`sql_list_stored_procs`	List all stored procedures
`sql_get_stored_proc_def`	Get stored procedure source code

Data Diagnostics

Tool	Description
`sql_find_data`	Search for a value across all columns in a table
`sql_check_foreign_keys`	Find orphaned records / FK violations
`sql_count_and_sample`	Row count + sample rows from a table
`sql_check_nulls`	Find NULL values in specified columns
`sql_compare_counts`	Compare parent/child table counts to find gaps
`sql_diagnose_issue`	Full diagnostic report on a table
`sql_get_query_plan`	Get execution plan for a query

🔐 Permission Model

Query Type	Behaviour
`SELECT`	Runs immediately, no confirmation needed
`INSERT / UPDATE / DELETE`	Shows preview first. Must call again with `confirm: true`
`DROP TABLE / ALTER / CREATE`	Shows preview first. Must call again with `confirm: true`
`DROP DATABASE / xp_cmdshell / BULK INSERT`	Always blocked, cannot be executed

💡 Example Questions to Ask the Agent

"List all configured SQL connections"
"Switch SQL connection to ecommerce"
"Run a query SELECT TOP 5 * FROM Payments on connection ecommerce"
"Compare row counts between Products and Categories in sweet-shop"
"Run a full diagnostic on the Orders table"

📦 Publishing to npm

To publish updates to npm:

npm login
npm publish --access public

Install Server

license - permissive license

quality

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

View all tools

Related MCP Servers

SQL Server MCP
Databases Developer Tools
bpamiri
A
license
A
quality
C
maintenance
Enables AI assistants to interact with Microsoft SQL Server databases through query execution, schema discovery, CRUD operations, stored procedures, and data export with built-in safety controls.
Updated 6 months ago (2026-02-09 19:32 UTC)
18
Apache 2.0
MSSQL MCP Server
Databases Developer Tools
combiz
A
license
-
quality
D
maintenance
Enables AI assistants to interact with Microsoft SQL Server databases through a standardized interface. Supports executing SQL queries, browsing database schemas, and viewing table data with flexible authentication options for both local and Azure SQL databases.
Updated a year ago (2025-07-02 16:16 UTC)
5
MIT
MSSQL MCP Server
Databases Developer Tools
mihai-dulgheru
A
license
-
quality
D
maintenance
Enables AI assistants to interact with Microsoft SQL Server databases via introspection and query tools. Supports single or multiple databases with read-only mode by default and an optional write capability.
Updated 3 months ago (2026-05-11 17:17 UTC)
373
4
MIT
MCP SQL Server
Databases Data Platforms
gigimento
F
license
-
quality
C
maintenance
Enables AI assistants to interact with SQL Server databases through tools for connectivity, schema exploration, SQL queries, and OEE metrics analysis.
Updated 2 months ago (2026-06-10 02:54 UTC)

View all related MCP servers

Related MCP Connectors

wgong-sqlite-mcp-server
Explore, query, and inspect SQLite databases with ease. List tables, preview results, and view det…
Power Automate MCP Server by Flow Studio
Debug, build, and manage Power Automate cloud flows with AI agents
TakoData-tako-mcp
Provide real-time data querying and visualization by integrating Tako with your agents. Generate o…

View all MCP Connectors

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/dkp5897/sql-server-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server

SQL Server MCP Server

🚀 Setup & Configuration

Method 1: Using a connections.json File (Easiest & Cleanest!) 🌟

Method 2: Environment Variable (DB_CONNECTIONS JSON Array)

Method 3: Single Database Configuration

🛠️ Available Tools (17 total)

Connection Management

Query Execution

Schema Inspection

Data Diagnostics

🔐 Permission Model

💡 Example Questions to Ask the Agent

📦 Publishing to npm

Maintenance

Resources

Looking for Admin?

Tools

Related MCP Servers

SQL Server MCP

MSSQL MCP Server

MSSQL MCP Server

MCP SQL Server

Related MCP Connectors

Latest Blog Posts

MCP directory API

Method 1: Using a `connections.json` File (Easiest & Cleanest!) 🌟

Method 2: Environment Variable (`DB_CONNECTIONS` JSON Array)