copia-seed 0.2.0

Interactive TUI database seeder

Copia

---

Seed your database without the hassle.

Most frameworks either ship a seeder with questionable decisions, or don't ship one at all. Copia is a TUI-based database seeder with its own declarative language — you describe what data you want, column by column, and Copia generates and inserts it.

id:         uuid()
username:   username()
email:      email(safe=True)
role:       enum('admin', 'editor', 'viewer')
created_at: past_date()

---

Why Copia

You have this table:

CREATE TABLE users (
  id           CHAR(36)      NOT NULL PRIMARY KEY,
  username     VARCHAR(50)   NOT NULL UNIQUE,
  email        VARCHAR(255)  NOT NULL UNIQUE,
  password     VARCHAR(255)  NOT NULL,
  role         ENUM('admin', 'editor', 'viewer') NOT NULL,
  created_at   DATE          NOT NULL
);

Without copia, seeding it looks like this:

INSERT INTO users (id, username, email, password, role, created_at)
VALUES
  ('a1b2c3d4-...', 'john_doe',    '[e-mail]',  '$2b$12$...', 'admin',  '2023-04-12'),
  ('e5f6g7h8-...', 'jane_smith',  '[e-mail]',  '$2b$12$...', 'editor', '2024-01-05'),
  ('i9j0k1l2-...', 'bob_99',      '[e-mail]',   '$2b$12$...', 'viewer', '2022-11-30'),
  ('m3n4o5p6-...', 'alice_w',     '[e-mail]', '$2b$12$...', 'admin',  '2023-08-19'),
  ('q7r8s9t0-...', 'charlie_k',   '[e-mail]','$2b$12$...','editor', '2024-03-02');
  -- ... 55 more rows. good luck with that.

With copia:

id:          uuid()
username:    username()
email:       email(safe=True)
password:    password(length=16)
role:        enum('admin', 'editor', 'viewer')
created_at:  past_date()

---

Features

• Simple language — if you know what a function call looks like, you know the Copia DSL
• Realistic data — built on Faker, 25+ generators out of the box
• Relational-aware — ref('table.column') samples from existing rows, so foreign keys just work
• Interactive TUI — write, preview, and insert without leaving your terminal

Installation

pip install copia-seed

Requires Python 3.13+. MySQL and MariaDB are supported.

Quickstart

copia init       # generate a config template
copia            # launch the TUI

Documentation

→ the official copia documentation is available here

---

License

MIT