Roadmap

Current Version: 1.13.0

Completed Features

All core features have been released:

Version	Feature	Status
v1.4.0	Test Data Generator + Merge	Released
v1.5.0	Sample (FK-aware sampling)	Released
v1.6.0	Shard (tenant extraction)	Released
v1.7.0	Convert (dialect conversion)	Released
v1.8.x	Validate + Glob Patterns	Released
v1.9.x	Diff (schema + data comparison)	Released
v1.10.0	Redact (data anonymization)	Released
v1.11.0	Graph + Order (ERD + FK ordering)	Released
v1.12.0	Query (DuckDB analytics)	Released
v1.12.x	MSSQL Support (fourth dialect)	Released
v1.13.0	JSON Schema Generation	Released

Upcoming Features

v1.14.0 — Migration Generation

Generate ALTER statements from schema differences:

sql-splitter migrate old.sql new.sql -o migration.sql
sql-splitter migrate old.sql new.sql --rollback -o rollback.sql

Features:

• Generate migration scripts (ALTER TABLE, CREATE INDEX)
• Multi-dialect migration output
• Rollback script generation
• Breaking change detection

v2.0.0 — Parallel Processing

Multi-threaded performance:

sql-splitter split dump.sql -o tables/ --parallel 8
sql-splitter convert dump.sql --parallel auto

Targets:

• 4x speedup on 8-core systems
• Linear scaling up to available cores
• Memory-bounded parallel processing

v2.1.0 — Schema Inference

Generate DDL from data-only dumps:

sql-splitter infer data-only.sql -o schema.sql
sql-splitter infer data.csv --table users --dialect mysql

Features:

• Type inference from INSERT values
• Primary key detection
• Index suggestion
• FK inference (heuristic)

v2.2.0 — Comment Conversion (MySQL ↔ PostgreSQL)

Preserve table and column comments during dialect conversion:

# MySQL COMMENT 'text' → PostgreSQL COMMENT ON statements
sql-splitter convert mysql.sql --to postgres -o pg.sql

# PostgreSQL COMMENT ON → MySQL inline COMMENT clauses
sql-splitter convert pg.sql --to mysql -o mysql.sql

Implementation:

Direction	Approach
MySQL → PostgreSQL	Extract inline COMMENT 'text' from CREATE TABLE, emit COMMENT ON COLUMN table.column IS 'text';
PostgreSQL → MySQL	Parse COMMENT ON statements, generate ALTER TABLE ... MODIFY COLUMN ... COMMENT 'text'

Notes:

• SQLite and MSSQL don’t support object comments, so comments are dropped when converting to these dialects
• Table comments and column comments both supported

Non-Goals

These features are explicitly out of scope:

• GUI interface — CLI only
• Database connection — File-based only
• Binary backup formats — No .bak (MSSQL)
• Stored procedure conversion — Too complex
• Real-time streaming — Batch processing only
• Cloud storage integration — Use pipes

Contributing

Want to contribute to a roadmap feature? See Contributing.

For feature requests, open an issue on GitHub.