Teaching an AI to read a relational database — including Oracle APEX

Short summary

The author built Legacy SQL Architect MCP, an MCP server that connects Claude to PostgreSQL, SQL Server, or Oracle databases in read-only mode for AI-driven schema inspection, impact analysis, and documentation generation. The latest release adds six Oracle APEX-specific tools for performance diagnostics, source extraction, debug analysis, config auditing, SQL runtime stats, and batch explain plans. All tools were verified against a live APEX 26.1 instance.

• •MCP server connects Claude to databases in strict read-only mode for schema inspection and analysis
• •Nine core tools cover schema inspection, data sampling, dependency graphs, ERD generation, and Java DAO code generation
• •New Oracle APEX tools diagnose slow pages, extract embedded code, audit config anti-patterns, and batch-explain SQL plans

Generated with AI, which can make mistakes.