Piper Data Dump Generator

Build realistic schemas, relationships, constraints, and production-like seed data without hand-editing every column the way many dump tools make you. Configure presets and relationship options, generate, pick PostgreSQL, MySQL, SQLite, or MongoDB, and download a clean dump—short path from idea to file.

Built by Adam - The Developer from Piper.

What This Project Does

• Runs entirely in the browser (no backend required)
• Generates schema + relationship graph + ordered insert plan
• Produces deterministic data from a seed value
• Exports downloadable dump files for:
  • PostgreSQL (.sql)
  • MySQL (.sql)
  • SQLite (.sql)
  • MongoDB (.js)

Tech Stack

• Next.js 16 (App Router)
• React 19
• TypeScript
• Tailwind CSS
• Radix UI Tooltip
• Vitest (smoke tests)

Local Development

Requirements

• Node.js >= 20.9.0 (required by Next.js 16)
• npm

Install

npm install

Start Dev Server

npm run dev

Open http://localhost:3000.

Build

npm run build

Lint

npm run lint

Tests

npm run test

How To Use

1. Setup: choose preset/config + seed + rows.
2. Review: inspect generated schema and insert order.
3. Export: download the target dialect dump file.

Generator semantics (exact numbers)

Advanced options apply deterministically from your seed:

• Composite key rate: exactly round(rate × entityCount) tables get a composite primary key (id + code) when fields per entity ≥ 2; code counts toward the column total.
• Many-to-many count: exactly min(requested, N) many-to-many relationships, where N is the number of allowed ordered entity pairs (depends on Include cycles).
• Relationship density: intended one-to-one + one-to-many count is round(density × N); the generator uses at most the pairs left after many-to-many, so the realized count is min(round(density × N), N - M).
• Self references: exactly min(requested, entityCount) self relationships.
• Optional field rate: among padding columns only, exactly round(rate × paddingCount) are nullable; among directed FK edges, exactly round(rate × directedCount) are nullable.

Project Structure

app/                      # Next.js app router pages + metadata routes
src/core/                 # Schema/data generation + dependency resolver
src/exporters/            # Dialect exporters
src/ui/                   # UI sections/components
src/constants/            # Grouped constants and templates
src/utils/                # Shared helpers (seeded RNG, download)

SEO / Site Metadata

SEO and site metadata are configured in:

• app/layout.tsx (title, description, OpenGraph, Twitter, icons, manifest)
• app/robots.ts
• app/sitemap.ts

Optional env for canonical/hosted URL:

NEXT_PUBLIC_SITE_URL=https://your-domain.com