Mcp Sql Server
@ryudg
About Mcp Sql Server
Just Read only
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mcp-sql": {
"command": "npx",
"args": [
"-y",
"@donggyunryu/mcp-sql"
],
"env": {
"DB_HOST": "<localhost>",
"DB_PORT": "1433",
"DB_DATABASE": "<your_database>",
"DB_USER": "<your_username>",
"DB_PASSWORD": "<your_password>",
"DB_ENCRYPT": "false",
"DB_TRUST_SERVER_CERTIFICATE": "true"
}
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Mcp Sql Server?
A Model Context Protocol server that provides comprehensive access to SQL databases, starting with MSSQL support. It enables AI assistants to inspect database schemas, execute queries, and perform database operations with enterprise‑grade security and performance monitoring.
How to use Mcp Sql Server?
Install globally via npm install -g @donggyunryu/mcp-sql or run with npx -y @donggyunryu/mcp-sql. Create a .env file with your MSSQL credentials (DB_HOST, DB_PORT, DB_DATABASE, DB_USER, DB_PASSWORD). Then add the server configuration to your MCP‑compatible assistant (e.g., Claude Desktop, Cursor) using the provided JSON settings. Restart the assistant and start with natural‑language queries like “Show me all tables in my database.”
Key features of Mcp Sql Server
- Full MSSQL support (MySQL and PostgreSQL coming soon)
- Schema inspection and metadata extraction
- Safe SQL execution with parameterized queries
- Performance monitoring and real‑time metrics
- SQL injection prevention and connection encryption
- Batch operations and transaction management
- Connection pooling with configurable settings
- Native integration with Claude Desktop, Cursor, and others
Use cases of Mcp Sql Server
- Exploring database schemas and table structures via natural language
- Running safe, ad‑hoc SQL queries through AI assistants
- Monitoring database performance and identifying slow queries
- Processing multiple queries in batch or managing transactions
- Generating performance reports and analyzing query statistics
FAQ from Mcp Sql Server
What databases does Mcp Sql Server support?
Currently only Microsoft SQL Server (MSSQL) is fully supported. MySQL and PostgreSQL support are planned for future releases.
What are the prerequisites to use Mcp Sql Server?
Node.js 18.0.0 or later, a running Microsoft SQL Server instance, and an MCP‑compatible AI assistant such as Claude Desktop or Cursor.
How do I configure Mcp Sql Server for Claude Desktop?
Add an entry to your claude_desktop_config.json with "command": "npx", "args": ["-y", "@donggyunryu/mcp-sql"], and the required environment variables (DB_HOST, DB_PORT, DB_DATABASE, DB_USER, DB_PASSWORD, etc.).
How can I test the database connection?
Run npx @donggyunryu/mcp-sql test:db or npm run test:db in a local environment.
What security measures are in place?
Connection encryption via TLS/SSL, parameter binding to prevent SQL injection, database user permission‑based access control, complete query logging, and comprehensive input sanitization.
More Databases MCP servers
Elasticsearch MCP Server
elastic
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
mcp_mysql_server
wenb1n-devModel Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
Neon MCP Server
neondatabase-labsMCP server for interacting with Neon Management API and databases
Chroma MCP Server
chroma-coreA Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
Comments