LocalDB

Provides tools to query and manage Microsoft SQL Server LocalDB via MCP, including listing databases, inspecting schemas, and executing SQL statements.

javascript

0

GitHub Stars

javascript

Language

6 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "sam2332-localdb-mcp": {
      "command": "node",
      "args": [
        "d:/MCP HOLE/localdb-mcp/build/index.js"
      ]
    }
  }
}

You can run a LocalDB MCP Server to let AI assistants query and interact with MSSQL LocalDB databases. It exposes practical tools to list databases, inspect schemas, run safe read queries, execute any SQL when needed, and retrieve metadata and procedures, making database exploration and integration with AI workloads straightforward.

How to use

Connect your MCP client to the LocalDB MCP Server and start issuing queries and commands. You can discover databases, switch between them, inspect table structures, retrieve sample data, and run a mix of read-only and write-enabled SQL statements depending on the tool you choose. Use the provided tools to navigate the LocalDB instance and its schemas without leaving your current AI workflow.

How to install

Prerequisites you need before installing the server:

Node.js 18 or higher
Microsoft SQL Server LocalDB installed
LocalDB instance named MSSQLLocalDB (default)

Install and build the MCP server dependencies, then run the server locally:

npm install
npm run build

Manual run and testing

Start the server for local testing using the standard npm workflow:

npm start

Alternative local runtime configuration

If you are using Claude Desktop or a similar MCP client, configure the local MCP server to run from a specific node process with the build index. The following configuration is an example you can adapt to your environment:

{
  "mcpServers": {
    "localdb_mcp": {
      "type": "stdio",
      "command": "node",
      "args": ["d:/MCP HOLE/localdb-mcp/build/index.js"]
    }
  }
}

Available tools

list_databases

List all databases on the LocalDB instance.

connect_database

Connect to a specific database.

list_tables

List all tables in the current database.

describe_table

Get detailed schema information including columns, keys, and indexes.

query

Execute SELECT queries in a safe, read-only mode.

execute_sql

Execute any SQL statement, including INSERT, UPDATE, DELETE, and DDL.

database_info

Get database metadata and statistics.

list_stored_procedures

List all stored procedures in the current database.

get_procedure_definition

Retrieve the source code of a stored procedure.

sample_data

Fetch sample rows from a table.