Skip to main content
Glama
sam2332

LocalDB MCP Server

by sam2332
copilot-instructions.md935 B
# LocalDB MCP Server ## Project Overview This is an MCP (Model Context Protocol) server that connects to Microsoft SQL Server LocalDB, enabling AI assistants to query databases, explore schemas, and execute SQL. ## SDK Reference - [MCP TypeScript SDK](https://github.com/modelcontextprotocol/typescript-sdk) - [MCP Documentation](https://modelcontextprotocol.io) ## Available Tools - `list_databases` - List all databases - `connect_database` - Connect to a database - `list_tables` - List tables - `describe_table` - Get table schema - `query` - Execute SELECT queries - `execute_sql` - Execute any SQL - `database_info` - Get database info - `list_stored_procedures` - List procedures - `get_procedure_definition` - Get procedure source - `sample_data` - Get sample data ## Development ```bash npm install npm run build npm start ``` ## Debugging Use VS Code's MCP debugging features - the server outputs to stderr for logging.

Latest Blog Posts

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/sam2332/localdb-mcp'

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