Description
database-design is an agent skill that gives principles and decision guidance for database design, rather than copyable SQL patterns. It covers choosing a database, such as PostgreSQL, Neon, Turso or SQLite, choosing an ORM, such as Drizzle, Prisma or Kysely, schema design with normalisation, primary keys and relationships, indexing strategy including composite indexes, query optimisation with N+1 detection and EXPLAIN ANALYZE, and safe migrations, including for serverless databases. Its content map lists a separate file for each decision, and it asks the agent to read only the file that matches the request. Use it when you are starting a schema, picking a database or ORM for a project, tuning slow queries, or planning a schema change on a live database. It is part of the sickn33/agentic-awesome-skills repository on GitHub, which has about 47,600 stars. The listing shows it as free, and it has about 2,200 installs. Its security audits show passes from Gen Agent Trust Hub, Socket and Snyk. Install it with npx skills add https://github.com/sickn33/agentic-awesome-skills --skill database-design.…
Highlights
- Database selection guidance
- ORM selection
- Schema design and normalisation
- Indexing and query optimisation
- Safe migrations
Ratings & Reviews
No ratings yet
Be the first to rate database-design.
People also visit
database-migrations
Safe, reversible database migration patterns: forward-only production changes
kotlin-exposed-patterns
JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing
database-design FAQ
What decisions does it help with?
Choosing a database and an ORM, designing a schema, indexing, optimising queries and running migrations.
Does it give copyable SQL?
No. The skill is written to teach the reasoning rather than copy fixed patterns.
Which databases does it compare?
PostgreSQL, Neon, Turso and SQLite, among others.
How is the guidance organised?
By decision, with a content map that points to the relevant file.
How do I install it?
Run npx skills add https://github.com/sickn33/agentic-awesome-skills --skill database-design.
Is it checked for security?
Its security audits show passes from Gen Agent Trust Hub, Socket and Snyk.
What are the best database-design alternatives?
Popular alternatives to database-design include drizzle, prisma-expert and database-migrations. See all database-design alternatives