databases
/databases
Use when creating, changing, or reviewing MongoDB/PostgreSQL/SQLite database work in a real repository, including schema, models, migrations, queries, indexes, transactions, connection config, backup/restore assumptions, dual-database desktop sync, or performance; follow repo-native tooling and meet the production database bar unless the user explicitly asks for a prototype.
- Author
- tamnguyendinh ↗
- Repository
- Anvien ↗
- Licence
- MIT
- Last repository change
- 25.10.2026
Assessment and security
- Files in this package
- 13
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 25.10.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
Use when creating, changing, or reviewing MongoDB/PostgreSQL/SQLite database work in a real repository, including schema, models, migrations, queries, indexes, transactions, connection config, backup/restore assumptions, dual-database desktop sync, or performance; follow repo-native tooling and meet the production database bar unless the user explicitly asks for a prototype.
Original author description
Use when creating, changing, or reviewing MongoDB/PostgreSQL/SQLite database work in a real repository, including schema, models, migrations, queries, indexes, transactions, connection config, backup/restore assumptions, dual-database desktop sync, or performance; follow repo-native tooling and meet the production database bar unless the user explicitly asks for a prototype.
How it works
- Purpose
- Core Rule
- Repo-First Rule
- Production Database Bar
- Implementation Rule
- Evidence Rule
- Tooling Boundary
- Prototype Exception
- Task Routing
- Reference Navigation
SKILL.md preview
--- name: databases description: Use when creating, changing, or reviewing MongoDB/PostgreSQL/SQLite database work in a real repository, including schema, models, migrations, queries, indexes, transactions, connection config, backup/restore assumptions, dual-database desktop sync, or performance; follow repo-native tooling and meet the production database bar unless the user explicitly asks for a prototype. license: MIT --- # Databases Skill Repo-first guidance for creating, changing, and reviewing MongoDB, PostgreSQL, or SQLite database work in real repositories. ## Purpose Use this skill when the task involves database schema, models, migrations, queries, indexes, transactions, seed data, connection config, backup/restore assumptions, or database performance. The goal is not to teach basic database syntax. The goal is to help the agent produce database work that is correct, production-ready, and consistent with the target repository. ## Core Rule Follow the user's requested action. If the user asks for review, review. If the user asks for a plan, plan. If the user asks for implementation, implementation is allowed. In every mode, database work must meet the production database bar unless the user explicitly asks for a throwaway prototype. ## Repo-First Rule Before proposing or editing database work, inspect the target repository first: - Database engine and version - ORM, query builder, or data-access layer - Migration framework and migration conventions - Existing schema, model, index, and query patterns - Connection config and environment conventions - Tests, seed data, fixtures, and deployment assumptions Follow repo-native tooling and patterns unless there is a clear reason not to. ## Production Database Bar Production-ready database work must account for: - Correctness: constraints, nullability, uniqueness, referential rules, validation, and ownership boundaries. - Migration safety: forward path, rollback or mitigation path, deploy order, locking risk, data volume, and backfill behavior. - Performance: expected queries, indexes, cardinality, pagination, aggregation cost, and query plans where relevant. - Concurrency: transaction boundaries, isolation assumptions, duplicate writes, retries, and out-of-order events. - Security: least privilege, secret handling, PII, encryption assumptions, and auditability. - Operations: backup/restore assumptions, monitoring, slow-query visibility, retention, and failure recovery. - Repo fit: existing ORM, migration framework, naming, config, and test patterns. Do not produce demo-only database work unless the user explicitly requests it. ## Implementation Rule When implementation is requested, create the production-safe version directly. Do not leave integrity, migration safety, indexing, transaction behavior, or operational checks as vague future hardening unless the user explicitly scopes them out. Keep edits scoped to the requested database behavior and the repository's established database layer. ## Evidence Rule Database recommendations need evidence appropriate to the risk. For performance work, prefer real query evidence: `EXPLAIN (ANALYZE, BUFFERS)`, `pg_stat_statements`, MongoDB explain/profiler output, row counts, index usage, and before/after measurements. For migrations, identify affected data, lock risk, deployment order, rollback or mitigation path, and verification queries. For schema changes, trace callers and consumers before changing shared data shapes. ## Tooling Boundary This skill defines the production-quality bar for database work. It does not replace the repository's ORM, migration framework, backup system, restore process, deployment process, or observability stack. Use the repository's own tooling first. ## Prototype Exception If the user explicitly asks for a prototype, demo, spike, or throwaway implementation, the work may be lighter. Even then, clearly mark which production concerns are intentionally omitted. ## Task Routing - Database selection: evaluate domain shape, consistency needs, query workload, operations, and team tooling. - Dual-database / Local-First sync: evaluate driver safety (pure-Go/prebuilt), SQLite WAL/lock configuration, dialect compatibility, and Repository abstraction. - SQLite production engineering: apply mandatory PRAGMA baseline (WAL, synchronous=NORMAL, busy_timeout=5000, foreign_keys=ON), eliminate upgrade deadlocks with BEGIN IMMEDIATE, enforce STRICT schemas, and execute hot zero-downtime backups. - Schema/model change: inspect models, migrations, constraints, indexes, serializers, API consumers, and tests. - Migration: use repo-native migration tooling; check data volume, locks, rollback/mitigation, and deploy order. - Query/index performance: inspect query shape, current indexes, table/collection size, cardinality, and plan evidence. - Backup/restore: inspect existing operational procedures; do not invent a generic production backup process. - Analytics/reporting SQL: if the task is BI/reporting/dashboard analysis rather than application database engineering, prefer a data-analysis skill. ## Reference Navigation | Engine / Domain | Target Task / Production Scenario | Mandatory Reference File | | :--- | :--- | :--- | | **Architectural Choice** | Evaluating MongoDB vs PostgreSQL vs SQLite tradeoffs | [`references/database-selection.md`](references/database-selection.md) | | **Local-First / Sync** | Desktop SQLite + Cloud PostgreSQL dual architecture & sync invariants | [`references/dual-database-sqlite-postgres.md`](references/dual-database-sqlite-postgres.md) | | **SQLite Production** | SQLite PRAGMAs, WAL concurrency, `BEGIN IMMEDIATE`, STRICT tables, hot backup | [`references/sqlite-best-practices.md`](references/sqlite-best-practices.md) | | **PostgreSQL Schema** | Schema design, safe migrations, constraints, pool settings | [`references/postgresql-best-practices.md`](references/postgresql-best-practices.md) | | **PostgreSQL Tuning** | `EXPLAIN (ANALYZE, BUFFERS)`, indexing (B-Tree, GIN, GiST, BRIN), configs | [`references/postgresql-performance.md`](references/postgresql-performance.md) | | **PostgreSQL Ops** | User roles, RLS, `pg_dump`, Streaming/Logical replication, PITR, Vacuum | [`references/postgresql-administration.md`](references/postgresql-administration.md) | | **PostgreSQL SQL** | CTEs, Recursive queries, Window functions, JSONB operators | [`references/postgresql-queries.md`](references/postgresql-queries.md) | | **PostgreSQL CLI** | `psql` meta-commands, script execution, batch imports, `.psqlrc` | [`references/postgresql-psql-cli.md`](references/postgresql-psql-cli.md) | | **MongoDB Operations** | CRUD, atomic operators, array filters, transactions, write concern | [`references/mongodb-crud.md`](references/mongodb-crud.md) | | **MongoDB Performance**| ESR indexing rule, `executionStats`, covered queries, index types | [`references/mongodb-indexing.md`](references/mongodb-indexing.md) | | **MongoDB Aggregation** | Multi-stage aggregation pipelines, `$lookup`, `$facet`, window stages | [`references/mongodb-aggregation.md`](references/mongodb-aggregation.md) | | **MongoDB Cloud** | Atlas tiers (M0 vs M10+), VPC peering, Atlas Vector Search, backups | [`references/mongodb-atlas.md`](references/mongodb-atlas.md) |
Files in this package (13)
- SKILL.md 7 KB
- references/database-selection.md 3 KB
- references/dual-database-sqlite-postgres.md 6 KB
- references/mongodb-aggregation.md 9 KB
- references/mongodb-atlas.md 9 KB
- references/mongodb-crud.md 8 KB
- references/mongodb-indexing.md 10 KB
- references/postgresql-administration.md 12 KB
- references/postgresql-best-practices.md 4 KB
- references/postgresql-performance.md 11 KB
- references/postgresql-psql-cli.md 10 KB
- references/postgresql-queries.md 10 KB
- references/sqlite-best-practices.md 16 KB
Versions
The database has no other skills named databases.
Database snapshot: 13.11.2026 · package version effd502c1eae (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 100maisongr-database
Maison GR method for safe database work. Use when changing a schema, writing or reviewing a migration, adding or changing queries, indexes or constraints, modelling data, writing data backfills or fixes, or diagnosing slow queries, in SQL databases (PostgreSQL, MySQL, SQLite) or… - 90database-engineer
Database architecture design, schema optimization, query performance tuning, and data migration. Handles PostgreSQL, MySQL, MongoDB, Redis. Use when user asks to design database, optimize queries, create migrations, or improve database performance. Do NOT use for frontend or application logic. - 100prisma-database-setup
Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.). Use when setting up a new project, changing databases, or troubleshooting connection issues. Triggers on "configure postgres", "connect to mysql", "setup mongodb", "sqlite setup". - 100database-engineering
Design, query, migrate, secure, and optimize relational databases, especially PostgreSQL. Use for schema design, SQL, indexes, transactions, concurrency, data integrity, backup/recovery, and production migrations. - 90database-design
Use when designing database schemas, reviewing data models, planning migrations, optimizing slow queries, or establishing database patterns. Covers relational (PostgreSQL, MySQL, SQLite), document (MongoDB), and ORM-integrated (Prisma, Drizzle, TypeORM) projects. - 100database-schema-designer
Use this skill when designing or reviewing database schemas for SQL and NoSQL databases. Covers normalization, indexing strategy, migration management with rollback safety, query optimization, and multi-tenant patterns. Supports PostgreSQL, MySQL, SQLite, MongoDB, and Vitess.