Legacy SQL Architect is an MCP server designed to provide AI agents, such as Claude Desktop, with a profound understanding of legacy databases including PostgreSQL, SQL Server, and Oracle. It allows AI to inspect schemas, retrieve stored procedure source code, analyze query performance, trace dependencies, generate documentation, and produce working Java code – all within a single conversational interface. Built for databases that have matured over years or decades, it supports complex PL/SQL packages where other tools may fail. The tool operates in a strict read-only mode, ensuring safety for production environments, and avoids framework lock-in by using pure Java + JDBC, enabling straightforward deployment as a native installer. It uniquely combines structural, logical, and real data insights, allowing the AI to understand relationships, predict impact, and streamline database-related development and maintenance workflows.
Key Features
01Deep analysis of legacy databases, including complex stored procedures and triggers.
02Strict read-only operation, ensuring data integrity and safety for production environments.
03Generates ready-to-compile Java DAO (Entity + Repository) classes directly from live schemas.
04Comprehensive dependency tracing and impact analysis across tables, procedures, views, and foreign keys.
05Execution plan analysis for identifying and optimizing slow queries.
061 GitHub stars
