2 مستودعات
Programmatically extracting structural metadata such as table and column references from SQL queries.
Distinct from Metadata Extraction: Existing metadata extraction candidates focus on AI, file systems, or UI elements rather than SQL structural analysis.
Explore 2 awesome GitHub repositories matching data & databases · SQL Metadata Extraction. Refine with filters or upvote what's useful.
sqlglot is a SQL parser and transpiler that represents queries as abstract syntax trees to enable structural analysis, modification, and semantic transformation. It functions as a dialect translator and query optimizer, converting SQL code between different database engines and simplifying syntax trees through rule-based normalization. The project provides a framework for defining custom SQL dialects by overriding tokenizers, parsers, and generators. It includes a lineage analyzer to track data flow from source tables through complex queries to identify the origin of specific columns. Additi
Extracts structural information from queries by identifying the specific columns and tables being referenced.
Soar is a suite of specialized tools designed for analyzing MySQL performance, advising on indexing, and optimizing SQL syntax. It functions as a performance analyzer, index advisor, and query optimizer to identify bottlenecks and suggest structural improvements for faster execution. The project distinguishes itself through a system for rewriting SQL statements into optimized equivalent versions using custom heuristic rules and patterns. It also features a dedicated index advisor that evaluates query patterns and database metadata to recommend the creation of new indexes. Its broader capabil
Generates unique fingerprints and processes SQL metadata to facilitate easier analysis and storage.