Use this order for all install methods: 1. Install SqlAugur 2. Save `appsettings.json` in the correct location 3. Add SqlAugur to your MCP client
Use this order for all install methods: 1. Install SqlAugur 2. Save appsettings.json in the correct location 3. Add SqlAugur to your MCP client config 4. Verify
Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.
Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.
| Tool | What it does |
|---|---|
| list_servers | Lists available SQL Server instances configured in appsettings.json. |
| list_databases | Lists all databases on a named server with names, IDs, states, and creation dates. |
| read_data | Executes a read-only SQL SELECT query. Only SELECT and WITH (CTE) queries are allowed. Results returned as JSON with a configurable row limit. |
| get_query_plan | Returns the estimated or actual XML execution plan for a SELECT query. |
| get_schema_overview | Concise Markdown schema overview: tables, columns, PKs, FKs, unique/check constraints, defaults. Supports compact mode, schema and table filtering. |
| describe_table | Comprehensive table metadata in Markdown: columns, data types, nullability, defaults, identity, computed expressions, indexes, FKs, constraints. |
| list_programmable_objects | Lists views, stored procedures, functions, and triggers. Filterable by type and schema. |
| get_object_definition | Returns the source definition (CREATE statement) of a programmable object. |
| get_extended_properties | Reads extended properties (descriptions, metadata) on tables, columns, and other objects. |
| get_object_dependencies | Shows what an object references and what references it — upstream and downstream dependency graphs. |
| get_plantuml_diagram | Generates a PlantUML ER diagram with tables, columns, PKs, and FK relationships. Saves to a .puml file. Supports compact mode, schema/table filtering, and a con |
| get_mermaid_diagram | Generates a Mermaid ER diagram with tables, columns, PKs, and FK relationships. Saves to a .mmd file. Supports compact mode, schema/table filtering, and a confi |
| sp_blitz | Overall SQL Server health check — prioritized findings for performance, configuration, and security. |
| sp_blitz_first | Real-time performance diagnostics — samples DMVs over an interval for waits, file latency, and perfmon counters. |
| sp_blitz_cache | Plan cache analysis — top queries by CPU, reads, duration, executions, or memory grants. |
| sp_blitz_index | Index analysis — missing, unused, and duplicate indexes with usage patterns. |
| sp_blitz_who | Active query monitor — what's running, blocking info, tempdb usage, query plans. |
| sp_blitz_lock | Deadlock analysis from the system_health extended event session. |
| sp_blitz_plan_compare | Cross-server query plan comparison — captures a plan snapshot on one server and compares it to the cached plan on a second server without using linked servers. |
| sp_pressure_detector | Diagnoses CPU and memory pressure — resource bottlenecks, high-CPU queries, memory grants, disk latency. |
| sp_quickie_store | Query Store analysis — top resource-consuming queries, plan regressions, wait statistics. |
| sp_quickie_cache | Plan cache analysis — high-impact queries ranked by impact score over the dm_exec__stats DMVs (the plan-cache companion to sp_quickie_store). |
| sp_health_parser | Parses the system_health extended event session for historical waits, disk latency, CPU, memory, and locking. |
| sp_log_hunter | Searches SQL Server error logs for errors, warnings, and custom messages. |
| sp_human_events_block_viewer | Analyzes blocking events from sp_HumanEvents sessions — blocking chains, lock details, waits. |
| sp_index_cleanup | Finds unused and duplicate indexes that are candidates for removal. |
| sp_query_repro_builder | Generates reproduction scripts for Query Store queries with parameter values. |
| sp_whoisactive | Monitors active sessions and queries — wait info, blocking details, tempdb usage, resource consumption. |
| list_toolsets | Lists available toolsets with status (available, enabled, not configured) and tool counts. |
| get_toolset_tools | Returns detailed tool and parameter info for a specific toolset before enabling it. |
| enable_toolset | Enables a toolset, making its tools available. Only works if the admin has enabled the toolset via the corresponding Enable config flag. |
{
"mcpServers": {
"sqlaugur": {
"command": "sqlaugur"
}
}
}From the project documentation. Replace placeholders and example paths before connecting.
Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.
Connect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.
Use the Supabase MCP server to inspect database schemas, query project data and retrieve docs through a project-scoped connection.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.