LocalDB MCP Server

An MCP (Model Context Protocol) server that enables AI assistants to query and interact with Microsoft SQL Server LocalDB (MSSQLLocalDB).

Features

This MCP server provides the following tools:

Prerequisites

• Node.js 18 or higher

• Microsoft SQL Server LocalDB installed

• LocalDB instance named MSSQLLocalDB (default)

Installation

Usage

With VS Code (GitHub Copilot)

The .vscode/mcp.json file is already configured. Just open VS Code in this directory and the MCP server will be available.

With Claude Desktop

Add this to your claude_desktop_config.json:

Manual Testing

Example Queries

Once connected, you can ask your AI assistant:

• "List all databases on LocalDB"

• "Connect to the AdventureWorks database"

• "Show me all tables in the current database"

• "Describe the Customers table"

• "Show me the first 10 rows from the Orders table"

• "How many records are in the Products table?"

• "What stored procedures exist in this database?"

Security Notes

• The query tool only allows SELECT statements for safety

• The execute_sql tool allows any SQL - use with caution

• Connections use Windows Authentication by default

• Only connects to LocalDB on the local machine

Development

Troubleshooting

Connection Issues

1. Ensure LocalDB is installed:

   sqllocaldb info

2. Start the LocalDB instance if not running:

   sqllocaldb start MSSQLLocalDB

3. Verify the instance is accessible:

   sqllocaldb info MSSQLLocalDB

Common Errors

• "Cannot connect to LocalDB": Make sure the MSSQLLocalDB instance exists and is running

• "Login failed": LocalDB uses Windows Authentication - ensure you have access

• "Database not found": Use list_databases to see available databases

License

MIT