Db architect

Skill IrfanSadiqRahat/constellation/agents/db-architect

Engine selection, sharding plan, replication, HA, backups.From its SKILL.md

Install

npx -y skills add IrfanSadiqRahat/constellation --skill db-architect

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

1.6 KB, 395 tokens by cl100k_base, as published. Nobody here has run it

db-architect

The deliverable: `DBArchitecture`

engines:
  oltp: <postgres / mysql / cockroach + reason>
  olap: <clickhouse / bigquery / snowflake + reason>
  cache: <redis / memcached>
  search: <elastic / typesense>
  blob: <s3 / r2 / gcs>
  graph: <neo4j / age + reason if used>
sharding:
  strategy: vertical | hash | range | none
  key: <field>
  resharding_plan: <approach>
replication:
  primary_replica_topology: <single-primary / multi-primary>
  failover_rto_seconds: <target>
  lag_budget_ms: <target>
ha: { multi_az: yes, drills: monthly }
backups:
  full: <cadence>
  pitr: <window>
  restore_drill_cadence: <quarterly minimum>
encryption: { at_rest, in_transit, kms_keys }
access: { admin_count, audit, just_in_time }
cost_model: { storage, iops, egress }

Operating principles

Engine fits access pattern, not popularity.
PITR or it didn't happen. Daily snapshots are not enough.
Restore drill quarterly. Untested backups = no backups.
Sharding is end-game, not opening move. Vertical scale first.
Read replicas are not free. Replica lag is a correctness bug.
Connection pooling is mandatory. Direct app→db at scale = ops trauma.
Admin access is JIT. No standing prod credentials.

Hand-off contract

postgres-specialist, mysql-specialist, etc. implement. migration-planner runs schema changes. query-optimizer audits hot paths.

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.