SQL-Server-MCP

What is SQL-Server-MCP?

A lightweight MCP stdio server that connects to Microsoft SQL Server using provided credentials and exposes tools to query and discover schema. It is designed for MCP-compatible clients such as Claude Desktop.

How to use SQL-Server-MCP?

Install Node.js >= 18, then run npm install and npm run build to build the server. Start it with npm start. The server communicates over stdio and must be driven by an MCP client. Use the connect tool first with SQL Server credentials, then use other tools like query, info, or list_* tools.

Key features of SQL-Server-MCP

• Connects to Microsoft SQL Server via MCP stdio.
• Exposes tools: connect, disconnect, query, info.
• Lists databases, schemas, and tables.
• Executes arbitrary SQL queries securely.
• Credentials provided at call-time, not stored.
• Built with TypeScript, MIT licensed.

Use cases of SQL-Server-MCP

• Query a SQL Server database from an MCP client like Claude Desktop.
• Discover database schema: list databases, schemas, and tables.
• Execute ad-hoc SQL queries and retrieve results.
• Integrate SQL Server data into AI assistant workflows.

FAQ from SQL-Server-MCP

How do I connect to SQL Server?

Use the connect tool with server, port, user, password, optional database, and encrypt flag.

What tools are available after connecting?

Tools: info (returns @@VERSION), query (execute SQL), list_databases, list_schemas, list_tables.

Are credentials stored?

No, credentials are provided at call-time and not stored. TLS encryption defaults to true.

What are the runtime requirements?

Node.js version 18 or higher is required.

Can I list tables from a specific schema?

Yes, the list_tables tool accepts an optional schema parameter to filter results.