SqlAugur
Gives Claude safe, read-only access to SQL Server databases with AST-level query validation using Microsoft's official T-SQL parser, not regex. Every query is parsed into a full syntax tree before execution, blocking comment injection and string literal tricks at the syntax level. Ships with built-in rate limiting to prevent runaway query loops, schema introspection tools that generate PlantUML and Mermaid ER diagrams, and optional integration with First Responder Kit, DarlingData, and sp_WhoIsActive for DBA diagnostics. Supports multiple named server connections and uses progressive tool discovery to keep the initial context window small. Install as a .NET global tool, run via Docker, or build from source.
- GitHub stars
- 4
- tools
- 31
- transport
- STDIO
- last updated
- Feb 18, 2026
Tools
31 toolsPublic tool metadata for what this MCP can expose to an agent.
list_serversLists available SQL Server instances configured in `appsettings.json`.
Lists available SQL Server instances configured in `appsettings.json`.
No parameter schema in public metadata yet.
list_databasesLists all databases on a named server with names, IDs, states, and creation dates.
Lists all databases on a named server with names, IDs, states, and creation dates.
No parameter schema in public metadata yet.
read_dataExecutes a read-only SQL SELECT query. Only `SELECT` and `WITH` (CTE) queries are allowed.
Executes a read-only SQL SELECT query. Only `SELECT` and `WITH` (CTE) queries are allowed.
No parameter schema in public metadata yet.
get_query_planReturns the estimated or actual XML execution plan for a SELECT query.
Returns the estimated or actual XML execution plan for a SELECT query.
No parameter schema in public metadata yet.
get_schema_overviewConcise Markdown schema overview: tables, columns, PKs, FKs, unique/check constraints, defaults.
Concise Markdown schema overview: tables, columns, PKs, FKs, unique/check constraints, defaults.
No parameter schema in public metadata yet.
describe_tableComprehensive table metadata in Markdown: columns, data types, nullability, defaults, identity, computed expressions, indexes, FKs, constraints.
Comprehensive table metadata in Markdown: columns, data types, nullability, defaults, identity, computed expressions, indexes, FKs, constraints.
No parameter schema in public metadata yet.
list_programmable_objectsLists views, stored procedures, functions, and triggers. Filterable by type and schema.
Lists views, stored procedures, functions, and triggers. Filterable by type and schema.
No parameter schema in public metadata yet.
get_object_definitionReturns the source definition (CREATE statement) of a programmable object.
Returns the source definition (CREATE statement) of a programmable object.
No parameter schema in public metadata yet.
get_extended_propertiesReads extended properties (descriptions, metadata) on tables, columns, and other objects.
Reads extended properties (descriptions, metadata) on tables, columns, and other objects.
No parameter schema in public metadata yet.
get_object_dependenciesShows what an object references and what references it — upstream and downstream dependency graphs.
Shows what an object references and what references it — upstream and downstream dependency graphs.
No parameter schema in public metadata yet.
get_plantuml_diagramGenerates a PlantUML ER diagram with tables, columns, PKs, and FK relationships.
Generates a PlantUML ER diagram with tables, columns, PKs, and FK relationships.
No parameter schema in public metadata yet.
get_mermaid_diagramGenerates a Mermaid ER diagram with tables, columns, PKs, and FK relationships.
Generates a Mermaid ER diagram with tables, columns, PKs, and FK relationships.
No parameter schema in public metadata yet.
sp_blitzOverall SQL Server health check — prioritized findings for performance, configuration, and security.
Overall SQL Server health check — prioritized findings for performance, configuration, and security.
No parameter schema in public metadata yet.
sp_blitz_firstReal-time performance diagnostics — samples DMVs over an interval for waits, file latency, and perfmon counters.
Real-time performance diagnostics — samples DMVs over an interval for waits, file latency, and perfmon counters.
No parameter schema in public metadata yet.
sp_blitz_cachePlan cache analysis — top queries by CPU, reads, duration, executions, or memory grants.
Plan cache analysis — top queries by CPU, reads, duration, executions, or memory grants.
No parameter schema in public metadata yet.
sp_blitz_indexIndex analysis — missing, unused, and duplicate indexes with usage patterns.
Index analysis — missing, unused, and duplicate indexes with usage patterns.
No parameter schema in public metadata yet.
sp_blitz_whoActive query monitor — what's running, blocking info, tempdb usage, query plans.
Active query monitor — what's running, blocking info, tempdb usage, query plans.
No parameter schema in public metadata yet.
sp_blitz_lockDeadlock analysis from the `system_health` extended event session.
Deadlock analysis from the `system_health` extended event session.
No parameter schema in public metadata yet.
sp_blitz_plan_compareCross-server query plan comparison without using linked servers.
Cross-server query plan comparison without using linked servers.
No parameter schema in public metadata yet.
sp_pressure_detectorDiagnoses CPU and memory pressure — resource bottlenecks, high-CPU queries, memory grants, disk latency.
Diagnoses CPU and memory pressure — resource bottlenecks, high-CPU queries, memory grants, disk latency.
No parameter schema in public metadata yet.
sp_quickie_storeQuery Store analysis — top resource-consuming queries, plan regressions, wait statistics.
Query Store analysis — top resource-consuming queries, plan regressions, wait statistics.
No parameter schema in public metadata yet.
sp_quickie_cachePlan cache analysis — high-impact queries ranked by impact score over the dm_exec_*_stats DMVs.
Plan cache analysis — high-impact queries ranked by impact score over the dm_exec_*_stats DMVs.
No parameter schema in public metadata yet.
sp_health_parserParses the `system_health` extended event session for historical waits, disk latency, CPU, memory, and locking.
Parses the `system_health` extended event session for historical waits, disk latency, CPU, memory, and locking.
No parameter schema in public metadata yet.
sp_log_hunterSearches SQL Server error logs for errors, warnings, and custom messages.
Searches SQL Server error logs for errors, warnings, and custom messages.
No parameter schema in public metadata yet.
sp_human_events_block_viewerAnalyzes blocking events from `sp_HumanEvents` sessions — blocking chains, lock details, waits.
Analyzes blocking events from `sp_HumanEvents` sessions — blocking chains, lock details, waits.
No parameter schema in public metadata yet.
sp_index_cleanupFinds unused and duplicate indexes that are candidates for removal.
Finds unused and duplicate indexes that are candidates for removal.
No parameter schema in public metadata yet.
sp_query_repro_builderGenerates reproduction scripts for Query Store queries with parameter values.
Generates reproduction scripts for Query Store queries with parameter values.
No parameter schema in public metadata yet.
sp_whoisactiveMonitors active sessions and queries — wait info, blocking details, tempdb usage, resource consumption.
Monitors active sessions and queries — wait info, blocking details, tempdb usage, resource consumption.
No parameter schema in public metadata yet.
list_toolsetsLists available toolsets with status (available, enabled, not configured) and tool counts.
Lists available toolsets with status (available, enabled, not configured) and tool counts.
No parameter schema in public metadata yet.
get_toolset_toolsReturns detailed tool and parameter info for a specific toolset before enabling it.
Returns detailed tool and parameter info for a specific toolset before enabling it.
No parameter schema in public metadata yet.
enable_toolsetEnables a toolset, making its tools available.
Enables a toolset, making its tools available.
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageReadme
SqlAugur
An MCP server that gives AI assistants safe, read-only access to SQL Server databases. Every query is parsed into a full AST using Microsoft's official T-SQL parser — not regex — so comment injection, string literal tricks, and encoding bypasses are blocked at the syntax level.
Details
- Repository
- github.com/mbentham/sqlaugur
- Website
- github.com/mbentham/SqlAugur
- Category
- Databases
- Package
SqlAugur- Transport
- STDIO
- Registry
- MCP registry, active
Related Databases MCP servers
View all
GLEIF MCP Serverolgasafonova/gleif-mcp-serverAccess the GLEIF LEI database for company verification, KYC, and ownership research.4stars
Ensembl Mcp Servercyanheads/ensembl-mcp-serverLook up genes, sequences, variants, homologs, and cross-database xrefs from Ensembl REST.3stars
Dbatools Mcp Serverdataplat/dbatools-mcp-serverMCP server for dbatools — exposes SQL Server management commands as MCP tools3stars
Open Food Factsdomdomegg/openfoodfacts-mcpSearch and contribute to the Open Food Facts database.3stars