Legacy SQL Architect MCP

MCP server that gives AI agents deep understanding of contemporary or legacy relational databases.

MCP server that gives AI agents deep understanding of legacy databases.

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 produce working Java code — all in a single conversation, without you copying a single line of SQL.

Works with legacy databases, not just modern ones.Full stored procedure source retrieval, trigger dependency mapping, and impact analysis designed for databases that have been running for years or decades — including large PL/SQL packages that other tools fail on.

Read-only by design.Connects in strict read-only mode. Physically cannot modify your database — no INSERT, no UPDATE, no DELETE. Safe to point at production.

No framework lock-in. No Docker.Pure Java + JDBC. No Spring, no ORM, no infrastructure to maintain. Runs as a lightweight native installer on Windows, macOS, and Linux.

Combines structure + logic + real data in one conversation.The AI inspects the schema, reads the stored procedure that processes orders, then samples real orders to understand why something is broken — without you copy-pasting anything between tools.

The AI understands relationships, not just tables.dependency_graphandfind_impacttrace how tables, triggers, procedures, views, and foreign keys connect — so the AI tells youwhat breaksbefore you change anything.

Generates working Java code, not pseudocode.generate_java_daoproduces ready-to-compile Entity + Repository classes (plain JDBC, Java 17+) directly from your live schema.

Six additional tools for diagnosing Oracle APEX application performance (Oracle-only):

Windows— download and runLegacySQLArchitectMCP-1.1.0.exe

sudo dpkg -i legacy-sql-architect-mcp_1.1.0_amd64.deb

sudo rpm -i legacy-sql-architect-mcp-1.1.0-1.x86_64.rpm

Editconfig.jsonin the installation directory:

{ "db_type": "postgresql", "db_url": "jdbc:postgresql://localhost:5432/your_database", "db_user": "your_user", "db_password": "your_password", "db_schema": "public", "data_sampler_rows": 10, "data_sampler_mask_sensitive": true }

db_typeaccepts:postgresql,sqlserver,oracle

Edit%APPDATA%\Claude\claude_desktop_config.json(Windows) or~/Library/Application Support/Claude/claude_desktop_config.json(macOS):

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

Restart Claude Desktop. A hammer icon (🔨) confirms the server is active.

"Inspect the schema and give me an overview of the data model."

"Get the source of all stored procedures and summarize the business logic."

"I need to rename a column in the orders table — use find_impact to tell me everything that would break."

Inspect the schema, generate a Mermaid ERD, sample the orders table, read all stored procedures, and produce complete Markdown documentation.

Analyze this query with query_plan_expert: SELECT * FROM orders WHERE status = 'PENDING' AND created_at > '2024-01-01' Is it using indexes? What would you recommend?

Generate Java DAO classes for all tables using package com.acme.repository, then write each file into src/main/java/com/acme/repository/.

Build the dependency graph. When a row is inserted into orders, what triggers fire and what procedures do they call?

- Setup Guide— installation, config.json reference, Claude Desktop setup, troubleshooting
- User Guide— all tools with prompt examples, multi-tool workflows, tips

# Run tests + build JAR mvn clean package # Windows installer (run on Windows, requires Java 21 with jpackage) JAVA_HOME="c:/Java_21" mvn clean package -P windows-exe -Dmaven.test.skip=true # Linux DEB (run inside Ubuntu/Debian container or system) mvn clean package -P linux-deb -Dmaven.test.skip=true # Linux RPM (run inside RHEL/Fedora container or system) mvn clean package -P linux-rpm -Dmaven.test.skip=true

Legacy SQL Architect MCP is distributed as native installers — not as a Maven library. There is no dependency to add to yourpom.xml. Download the installer for your platform fromGitHub Releasesand follow theSetup Guide.

Provides AI agents with direct access to query, search, and analyze MySQL databases.