Connect Claude Desktop (or any MCP-compatible AI client) to your PostgreSQL, SQL Server, or Oracle database and let the AI inspect schemas, read
Connect Claude Desktop (or any MCP-compatible AI client) to your PostgreSQL, SQL Server, or Oracle database and let the AI inspect schemas, read stored procedures, analyze query performance, trace dependencies, generate documentation, and. That is what the legacy sql architect mcp mcp server brings to an AI assistant: the same capability, reachable through the Model Context Protocol rather than a separate app or dashboard.
Setup follows the usual MCP pattern — install or clone the server, register it in your client's configuration file, restart the client.
The server publishes 9 tools. What each one is for:
inspect_schema — Tables, columns, types, primary keys, foreign keysdata_sampler — Sample rows with automatic sensitive-column maskingget_procedure_source — Full source code of stored procedures and functionsquery_plan_expert — Execution plan analysis, full table scan detectiondependency_graph — FK chains, trigger→procedure call chains, view dependenciesgenerate_mermaid_erd — Entity-Relationship Diagram in Mermaid formatgenerate_documentation — Complete Markdown documentation for the entire schemafind_impact — Everything that depends on a given tablegenerate_java_dao — Java Entity + Repository classes (plain JDBC) per tablePlenty of database access servers cover similar ground. The differences that matter in practice are scope of access and how much setup stands between you and a working tool call. Legacy Sql Architect MCP's toolset — inspect_schema, data_sampler, get_procedure_source and 6 more — is a fair guide to whether it matches your workflow. It is maintained by tabforgeai; worth a glance at recent repository activity before you build anything load-bearing on it.
SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.
| Tool | What it does |
|---|---|
| inspect_schema | Tables, columns, types, primary keys, foreign keys |
| data_sampler | Sample rows with automatic sensitive-column masking |
| get_procedure_source | Full source code of stored procedures and functions |
| query_plan_expert | Execution plan analysis, full table scan detection |
| dependency_graph | FK chains, trigger→procedure call chains, view dependencies |
| generate_mermaid_erd | Entity-Relationship Diagram in Mermaid format |
| generate_documentation | Complete Markdown documentation for the entire schema |
| find_impact | Everything that depends on a given table |
| generate_java_dao | Java Entity + Repository classes (plain JDBC) per table |
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.