skills.rest
HelgeSverre
HelgeSverreCOMMUNITY
Explore all skills by this author →
Website𝕏@helgesverreGitHub

sql-splitter

Automate splitting, merging, validating, converting dialects, sampling, sharding, ERD generation, and reordering of SQL dump files via CLI across MySQL, and more.

12|1|Updated Sep 30, 2025
Search Tags:#validation#split#ERD#DuckDB#sql-dumps#dialect-conversion
One-click install
npx skills add https://github.com/HelgeSverre/sql-splitter --skill sql-splitter
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-splitter
Source: https://github.com/HelgeSverre/sql-splitter/tree/main/skills/sql-splitter
Command: npx skills add https://github.com/HelgeSverre/sql-splitter --skill sql-splitter

SYSTEM DOCUMENTATION & REQUIREMENTS

## What problem does it solve? This Skill addresses the challenge of managing large SQL dump files by enabling safe, scalable manipulation, validation, and migration workflows.

## Core Features & Use Cases

  • Split large dumps into per-table files for easier editing and targeted imports.
  • Validate integrity, analyze structure, and convert between MySQL, PostgreSQL, SQLite, and MSSQL dialects.
  • Generate FK-safe samples, shard multi-tenant dumps, reorder for safe imports, and run embedded SQL analytics.
  • Use for migrations, CI validation, dev seeding, and schema visualization.

### Quick Start Install the sql-splitter binary (e.g., cargo install sql-splitter) and try a simple workflow:

  • Split a dump: sql-splitter split dump.sql --output tables/
  • Analyze: sql-splitter analyze dump.sql --progress

Frequently Asked Questions about sql-splitter

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I split a large SQL dump file into individual tables?▼

You can split a large SQL dump file by running the sql-splitter binary against it, which streams the file in a memory-efficient fashion and outputs per-table files for targeted editing and imports.

Can I convert SQL dumps between MySQL, PostgreSQL, SQLite, and MSSQL dialects?▼

Yes, SQL dump dialect conversion between MySQL, PostgreSQL, SQLite, and MSSQL is supported, allowing you to transform dump files to match your target database system during migrations.

What is the best way to validate SQL dump integrity before importing?▼

Validating SQL dump integrity involves analyzing the file structure and checking constraints to ensure safe imports. Using a streaming CLI tool prevents memory exhaustion when processing large dump files.

Do I need to install any dependencies to use sql-splitter for SQL dump analysis?▼

Yes, you need to install the sql-splitter binary via cargo install sql-splitter before you can split, analyze, or validate SQL dumps using this Skill's automation workflows.

How do I generate an ERD from an existing SQL dump file?▼

Generating an ERD from a SQL dump file involves analyzing the schema and foreign key relationships within the dump, producing a visual representation of the database structure.

Can I shard multi-tenant SQL dumps or generate FK-safe samples?▼

Yes, you can shard multi-tenant SQL dumps and generate FK-safe samples by leveraging the splitting and reordering capabilities to maintain referential integrity during data extraction.

Related Skills

Explore More Software Engineering Skills→
cenjiecenjie

drizzle-orm-patterns

Automate type-safe Drizzle ORM schemas, queries, relations, transactions, and migrations.

Community
Advanced
clawdataclawdata
24

duckdb

Query local DuckDB warehouses with SQL and ingest CSV, Parquet, and JSON files.

Official
Intermediate
Alex-65Alex-65

tdc-database

Automate MySQL schema, migrations, seeds, and backups via CLI scripts.

Community
Advanced
lciaccilciacci

sqlfluff

Lint standalone SQL files with sqlfluff and project dialect configuration.

Community
Intermediate