agentleFS
Sign inStart free
salmandevsalmandev/everything-gemini/skills/database-architect/SKILL.md

database-architect

Skill2 starsChanged 28 days agoApache-2.0View on GitHub

Designs relational and document database schemas, crafts zero-downtime database migrations, optimizes complex queries, and configures ORMs (Prisma, Drizzle, SQLAlchemy).

14 other projects use a version of this.

Adopted by

Most recently taken up by

Used with

Projects with it also use security-engineer and system-architect.

Other files people use alongside this one.

Files found in the same public projects as a version of this one, more often than they turn up anywhere else. Each project counts once, large collections count for less, and this file's own repository is left out.
  • belokonmSkill

    security-engineer

    Expert in infrastructure security, DevSecOps pipelines, and zero-trust architecture design.

    Also in 3 projects that use this

  • nahisahoSkill

    system-architect

    Copilot agent that assists with architecture design, C4 model diagrams, ADR creation, and tradeoff analysis

    Also in 3 projects that use this

The file

We split this skill into the rules it gives an agent

3 rules. 0 are common, 1 is distinctive, and 2 are very specific to this project.

  • 0

    Common

    Most of the 14 edited versions we read keep these.

  • 1

    Distinctive

    This author's own choices. Worth a look.

  • 2

    Very specific

    Tied to their project's names, files or tools. Probably skip.

  • Common
  • Distinctive
  • Very specific
  1. Distinctive:

    Primary Keys: Use UUIDv7 or ULIDs for distributed systems, or identity integers for internal lookups.

    line 14
  2. Very specific:

    Foreign Keys: Always define explicit foreign key constraints with appropriate ON DELETE behavior (CASCADE, RESTRICT, or SET NULL).

    line 15
  3. Very specific:

    Timestamps: Every table must have created_at TIMESTAMPTZ DEFAULT now() and updated_at TIMESTAMPTZ DEFAULT now().

    line 16

“Common” is measured: kept by at least 6 in 10 of the 14 edited versions of this file we could read. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Keep what fits and drop the rest. Your version, ready for your agents.
Files
SKILL.md

Database Architect

This skill guides data modeling, schema evolution, index tuning, and zero-downtime migration workflows.

Core Directives

1. Schema Design Standards

  • Primary Keys: Use UUIDv7 or ULIDs for distributed systems, or identity integers for internal lookups.
  • Foreign Keys: Always define explicit foreign key constraints with appropriate ON DELETE behavior (CASCADE, RESTRICT, or SET NULL).
  • Timestamps: Every table must have created_at TIMESTAMPTZ DEFAULT now() and updated_at TIMESTAMPTZ DEFAULT now().

2. Zero-Downtime Migrations (Expand/Contract Pattern)

  • Never rename or delete a column in a single migration:
    1. Phase 1 (Expand): Add the new column as nullable or with a default. Deploy code that writes to both columns.
    2. Phase 2 (Backfill): Backfill existing records asynchronously.
    3. Phase 3 (Switch): Deploy code that reads from the new column only.
    4. Phase 4 (Contract): Remove the old column.
  • Safe Index Creation: In PostgreSQL, always use CREATE INDEX CONCURRENTLY to avoid blocking read/write queries.

For the zero-downtime migration checklist, see references/migration-checklist.md.

Download now (ZIP)

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

  • It worked
  • Partly
  • It didn't
What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

Check your setup, free