dbmcp-sql-lineage

Column-level SQL lineage extraction powering dbmcp — the single-binary MCP server for MySQL, MariaDB, PostgreSQL, and SQLite.

What you get

• extract() maps each output column to its physical table.column sources
• AST-based via sqlparser — accepts any Dialect
• Reads (SELECT) and writes (INSERT, UPDATE, DELETE, CREATE TABLE AS SELECT, MERGE); writes also record a target
• Resolves CTEs, derived tables, joins, and qualified references
• Fail-closed — unresolvable columns (SELECT * over base tables, ambiguous unqualified columns in joins) abort the whole extraction
• Never connects to or executes against a database — analyzes SQL text only

See the main crate: dbmcp · Website · Docs