SQL Splitter

https://www.sql-splitter.dev/docs

Admin

SQL Splitter is a blazing fast, memory-efficient, and multi-dialect SQL dump toolkit for splitting,...

Tokens:474

Snippets:9

Trust Score:3

Update:3 months ago

Show doc for...

Tokens:

Raw

### Install sql-splitter

Source: https://www.sql-splitter.dev

Installation methods for various environments.

```bash
curl -fsSL https://sql-splitter.dev/install.sh | sh
```

```bash
brew install helgesverre/tap/sql-splitter
```

```bash
cargo install sql-splitter
```

--------------------------------

### Database Migration Workflows

Source: https://www.sql-splitter.dev

Convert SQL dialects or stream directly to a database.

```bash
# Convert MySQL to PostgreSQL
sql-splitter convert mysql.sql --to postgres -o postgres.sql

# Stream directly to database
sql-splitter convert mysql.sql.gz --to postgres -o - | psql "$PG_CONN"
```

--------------------------------

### Create Development Datasets

Source: https://www.sql-splitter.dev

Sample data with integrity preservation and redact sensitive information.

```bash
# Sample 10% with FK integrity preserved
sql-splitter sample prod.sql -o dev.sql --percent 10 --preserve-relations

# Anonymize sensitive data
sql-splitter redact dev.sql -o safe.sql --hash "*.email" --fake "*.name"
```

--------------------------------

### List Split Tables

Source: https://www.sql-splitter.dev

Verify the output directory after splitting a dump.

```bash
# Each table gets its own .sql file
ls tables/
# users.sql orders.sql products.sql ...
```

--------------------------------

### Split SQL Dump

Source: https://www.sql-splitter.dev

Splits a large SQL dump file into individual files per table.

```bash
sql-splitter split database.sql --output=tables
```

--------------------------------

### Validate SQL Dumps

Source: https://www.sql-splitter.dev

Perform integrity and syntax validation on SQL files with JSON output.

```bash
# Validate all dumps with JSON output
sql-splitter validate "dumps/*.sql" --strict --json --fail-fast
```

Tokens:

Raw