SqlAugur — Claude Code MCP server: SQL access and setup
SqlAugur lets AI clients inspect SQL Server with read-only queries, schema tools, diagrams, and diagnostics. It fits projects that need database access through MCP.
Open on GitHubWhat SqlAugur does
SqlAugur connects an MCP client to one or more named SQL Server connections. Only SELECT statements and CTEs are accepted. Each query is parsed into a complete T-SQL AST with Microsoft's parser, so comment-based tricks, string-literal escapes, and encoding workarounds are rejected before execution.
The server can map schemas, document tables, show dependencies, create PlantUML or Mermaid ER diagrams, and inspect estimated or actual execution plans. Optional integrations cover First Responder Kit, DarlingData, and sp_WhoIsActive. Tools are exposed progressively, while throughput and concurrency limits help contain repeated query calls.
The global tool requires the .NET 10.0 runtime. Store server connections in appsettings.json, then add sqlaugur to the MCP client configuration. The global installation cannot proceed without the required .NET runtime.
What it helps with
- run read-only SQL queries against a configured server
- inspect tables, keys, defaults, and constraints
- generate a PlantUML or Mermaid ER diagram
- examine an estimated or actual query plan
- diagnose SQL Server with optional DBA tools
Example prompts for the agent
- Inspect the
productiondatabase schema and list its keys and constraints. - Run a read-only query that finds the latest rows in the target table.
- Create a Mermaid ER diagram for this database and explain its relationships.
How to install SqlAugur
Install
The MCP registry has no launch command for it: see the repository README
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about SqlAugur
How do I install SqlAugur in Claude Code?
Install the .NET 10.0 runtime, then run dotnet tool install -g SqlAugur. Save the connection settings in ~/.config/sqlaugur/appsettings.json on Linux/macOS or %APPDATA%\sqlaugur\appsettings.json on Windows, add an MCP entry using sqlaugur, and verify it by asking the client to call list_servers.
What does SqlAugur do?
It gives AI clients read-only access to SQL Server. It validates queries with an AST, exposes schema and diagram tools, analyzes execution plans, and can provide DBA diagnostics.
Can SqlAugur execute write queries?
No. The server permits SELECT and CTE queries only, and diagnostic procedure parameters are filtered to prevent write operations.
