List view
## Goal Deliver a functional MVP that can parse SQL `CREATE TABLE` statements and generate equivalent PostgreSQL-compatible schemas for migration. --- ## Requirements ### 1. SQL Parsing - Parse `CREATE TABLE` definitions from at least one SQL dialect (e.g., MySQL, SQLite). - Extract: - Table names - Column names, types, and constraints (`NOT NULL`, `PRIMARY KEY`, etc.) - Foreign keys - Indexes (basic support) - Default values ### 2. Dialect Handling - Abstract dialect-specific features: - e.g., `AUTO_INCREMENT` → `SERIAL` in PostgreSQL - Convert types and syntax to PostgreSQL equivalents ### 3. PostgreSQL Output - Generate valid PostgreSQL `CREATE TABLE` statements - Ensure correct table creation order (respect foreign key dependencies) - Expose functionality via: - CLI interface or - Programmatic API ### 4. Validation - Include automated tests covering: - Basic table definitions - Tables with foreign keys - Various data types and constraints - Verify logical equivalence of input and output schemas --- ## Deliverables - MVP codebase (CLI or API) - SQL parser + PostgreSQL schema generator - Example SQL input/output pairs - Unit + integration tests - CI pipeline (basic test runner) --- ## Success Criteria - Developers can run the tool to convert SQL schemas to PostgreSQL with no manual changes - ≥ 80% test coverage for core parsing and generation logic - CI passes all tests on push/PR
Overdue by 3 month(s)•Due by September 30, 2025•0/8 issues closed