# 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.