BosskuAI Database Engineering
Use this skill when schema, query behavior, indexes, migrations, data consistency, or database choice affects the outcome.
Database coverage
- MariaDB / MySQL: InnoDB constraints, indexes, generated columns, JSON tradeoffs, online migration risk, replication-aware changes.
- PostgreSQL: constraints, partial indexes, JSONB, GIN/GiST, CTEs, advisory locks,
EXPLAIN ANALYZE.
- SQLite: local/dev/test constraints, WAL mode, type affinity, concurrency limits, migration compatibility.
- MongoDB: document shape, compound indexes, aggregation pipelines, schema validation, write concern, and bounded document growth.
Review checklist
- Data model matches the business invariant, not only the current UI.
- Constraints exist in the database for rules that must never be violated.
- Indexes match real
WHERE, JOIN, ORDER BY, and uniqueness paths.
- Migrations are reversible or have a safe forward-only rollback plan.
- High-volume changes are chunked and safe for production traffic.
- Query plans are checked before claiming a query is fast.
- Soft deletes, tenancy, status transitions, and audit trails are modeled explicitly.
Guardrails
- Do not solve missing constraints only in application code.
- Do not add indexes blindly; check selectivity and write cost.
- Do not use MongoDB as a shortcut for unclear relational modeling.
- Do not assume MySQL, MariaDB, PostgreSQL, and SQLite support the same DDL.
Output format
Database engine: [engine/version if known]
Invariant to protect: [rule]
Schema/query findings:
P0/P1/P2 — [issue] — [fix]
Migration plan: [safe steps]
Index plan: [index + reason]
Verification: [EXPLAIN/tests/constraints checked]
References
../../references/playbooks/bosskuai-database-engineering-playbook.md../../references/checklists/database-engineering-checklist.md../../references/checklists/expert-cofounder-stack-checklist.md
1---2name: bosskuai-database-engineering3description: Use this for SQL and NoSQL database design across MariaDB, MySQL, PostgreSQL, SQLite, MongoDB, indexing, transactions, migrations, constraints, query plans, and data correctness.4---5
6# BosskuAI Database Engineering
7
8Use this skill when schema, query behavior, indexes, migrations, data consistency, or database choice affects the outcome.
9
10## Database coverage
11
12- MariaDB / MySQL: InnoDB constraints, indexes, generated columns, JSON tradeoffs, online migration risk, replication-aware changes.
13- PostgreSQL: constraints, partial indexes, JSONB, GIN/GiST, CTEs, advisory locks, `EXPLAIN ANALYZE`.
14- SQLite: local/dev/test constraints, WAL mode, type affinity, concurrency limits, migration compatibility.
15- MongoDB: document shape, compound indexes, aggregation pipelines, schema validation, write concern, and bounded document growth.
16
17## Review checklist
18
19- Data model matches the business invariant, not only the current UI.
20- Constraints exist in the database for rules that must never be violated.
21- Indexes match real `WHERE`, `JOIN`, `ORDER BY`, and uniqueness paths.
22- Migrations are reversible or have a safe forward-only rollback plan.
23- High-volume changes are chunked and safe for production traffic.
24- Query plans are checked before claiming a query is fast.
25- Soft deletes, tenancy, status transitions, and audit trails are modeled explicitly.
26
27## Guardrails
28
29- Do not solve missing constraints only in application code.
30- Do not add indexes blindly; check selectivity and write cost.
31- Do not use MongoDB as a shortcut for unclear relational modeling.
32- Do not assume MySQL, MariaDB, PostgreSQL, and SQLite support the same DDL.
33
34## Output format
35
36```text
37Database engine: [engine/version if known]
38Invariant to protect: [rule]
39Schema/query findings:
40 P0/P1/P2 — [issue] — [fix]
41Migration plan: [safe steps]
42Index plan: [index + reason]
43Verification: [EXPLAIN/tests/constraints checked]
44```
45
46## References
47
48- `../../references/playbooks/bosskuai-database-engineering-playbook.md`
49- `../../references/checklists/database-engineering-checklist.md`
50- `../../references/checklists/expert-cofounder-stack-checklist.md`
aibot88