How do I install the legacy sql architect mcp server?

This profile does not contain a verified copy-paste launch configuration. Follow the current project documentation to confirm the runtime, entry point, transport and authentication before registering it in your client.

SSyncDev

Start a project

Legacy Sql Architect MCP Server

Connect Claude Desktop (or any MCP-compatible AI client) to your PostgreSQL, SQL Server, or Oracle database and let the AI inspect schemas, read

Local serverstdio

What is the Legacy Sql Architect MCP Server?

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

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

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
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
inspect_apex_performance	App/page/region/LOV overview, slowest pages, anti-pattern recommendations
get_apex_source	Extract embedded APEX code across 12 component types (regions, processes, LOVs, …)
inspect_apex_debug	Reconstruct page views from APEX debug messages and drill into the slowest steps
apex_config_audit	Static audit: pagination COUNT(), unbounded max-rows, uncached LOVs, too many server-side DAs
apex_sql_runtime_stats	Real runtime cost of an app's SQL from V$SQL (buffer gets, elapsed, executions)
apex_explain_batch	Batch EXPLAIN PLAN of an app's SQL with red-flag detection (full scans, Cartesian joins)

How to install the Legacy Sql Architect MCP Server

{
  "mcpServers": {
    "legacy-sql-architect": {
      "command": "C:\\Program Files\\LegacySQLArchitectMCP\\LegacySQLArchitectMCP.exe"
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Example prompts to try

“Use Legacy Sql Architect MCP to inspect schema.”
“Use Legacy Sql Architect MCP to data sampler.”
“Use Legacy Sql Architect MCP to get procedure source.”

Frequently asked questions

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 Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.