PL/SQL Intelligence
A solo builder uses this tool to analyze, validate, and understand PL/SQL code in Oracle databases with both live connections and offline static analysis.
Overview
PL/SQL Intelligence MCP is a MCP server for the Build phase that offers live Oracle PL/SQL tools and offline analyze, lineage, and SAST for agent-assisted database work.
What is this MCP server?
- Live Oracle DB connection tools for real-time queries and inspection
- Offline PL/SQL analysis including lineage tracing and SAST security scanning
- Code intelligence for stored procedures, functions, and package analysis
- Server version 0.1.0
- OCI identifier ghcr.io/muhdur/plsql-mcp:0.1.0
- Combines live DB tools with offline analyze, lineage, and SAST per description
Community signal: 1 GitHub stars.
What problem does it solve?
Refactoring Oracle apps stalls when PL/SQL dependency graphs and security issues live only in DBAs’ heads or disconnected desktop tools.
Who is it for?
Builders inheriting large PL/SQL codebases who want MCP-driven analysis before changing APIs or reports tied to stored logic.
Skip if: Teams without Oracle/PL/SQL, beginners who only need simple CRUD on Postgres, or orgs that require vendor-supported database plugins only.
What do I get? / Deliverables
After setup, your agent can invoke MCP tools to inspect PL/SQL, trace lineage, and surface SAST signals from live or offline sources.
- Agent-callable PL/SQL analyze and lineage MCP tools
- Offline SAST-oriented feedback on PL/SQL modules
- Clearer dependency maps before backend or reporting changes
Recommended MCP Servers
Journey fit
This tool is essential during the build phase when developers are writing and optimizing Oracle database logic, requiring real-time feedback and code quality analysis. PL/SQL analysis fits squarely in backend development, as it directly supports Oracle database schema inspection, stored procedure analysis, and SQL security scanning.
How it compares
PL/SQL analysis and lineage MCP, not a generic SQL autocomplete or schema-only read-only server.
Common Questions / FAQ
Who is PL/SQL Intelligence MCP for?
Oracle maintainers and solo builders who need agents to understand packages, dependencies, and security patterns in PL/SQL.
When should I use PL/SQL Intelligence MCP?
Use it during backend Build work when planning refactors, audits, or documentation of stored procedures and their lineage.
How do I add PL/SQL Intelligence MCP to my agent?
Run ghcr.io/muhdur/plsql-mcp:0.1.0 with stdio MCP registration and configure Oracle connectivity or offline source paths per the GitHub repo.