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 by asking your assistant to call list_servers. That is what the sqlaugur mcp server brings to an AI assistant: the same capability, reachable through the Model Context Protocol rather than a separate app or dashboard.
The server publishes 14 tools. What each one is for:
list_servers — Lists available SQL Server instances configured in appsettings.jsonlist_databases — Lists all databases on a named server with names, IDs, states, and creation datesread_data — Executes a read-only SQL SELECT query. Only SELECT and WITH (CTE) queries are allowed. Results returned as JSON with a configurable row limitget_query_plan — Returns the estimated or actual XML execution plan for a SELECT queryget_schema_overview — Concise Markdown schema overview: tables, columns, PKs, FKs, unique/check constraints, defaults. Supports compact mode, schema and table filteringdescribe_table — Comprehensive table metadata in Markdown: columns, data types, nullability, defaults, identity, computed expressions, indexes, FKs, constraintslist_programmable_objects — Lists views, stored procedures, functions, and triggers. Filterable by type and schemaget_object_definition — Returns the source definition (CREATE statement) of a programmable objectget_extended_properties — Reads extended properties (descriptions, metadata) on tables, columns, and other objectsget_object_dependencies — Shows what an object references and what references it — upstream and downstream dependency graphsget_plantuml_diagram — Generates a PlantUML ER diagram with tables, columns, PKs, and FK relationships. Saves to a .puml file. Supports compact mode, schema/tableget_mermaid_diagram — Generates a Mermaid ER diagram with tables, columns, PKs, and FK relationships. Saves to a .mmd file. Supports compact mode, schema/table filteringSetup follows the usual MCP pattern — install or clone the server, register it in your client's configuration file, restart the client. The configuration blocks on this page cover the common clients.
Among the database access options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. Sqlaugur's toolset — list_servers, list_databases, read_data and 11 more — is a fair guide to whether it matches your workflow. It is maintained by mbentham; worth a glance at recent repository activity before you build anything load-bearing on it.
This entry was verified against Sqlaugur's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.
| 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 configurable table limit (max 200). |
| 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 configurable table limit (max 200). |
| verbose | Return all columns with no truncation. |
| includeQueryPlans | Include XML execution plan columns in the output. |
{
"mcpServers": {
"sqlaugur": {
"command": "sqlaugur"
}
}
}Configuration as documented by the project. Restart the client after saving.
Read-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
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.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.