schema-design
Designs and implements PostgreSQL schemas for domain entities.
Install
mkdir -p .claude/skills/schema-design && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/14499" && unzip -o skill.zip -d .claude/skills/schema-design && rm skill.zipInstalls to .claude/skills/schema-design
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Design a PostgreSQL schema for a new domain entity.Key capabilities
- →Understand context from arguments
- →Read relevant source files
- →Plan the approach for schema design
- →Implement the schema solution
- →Verify the schema with tests
How it works
The skill designs a PostgreSQL schema by understanding the provided context, reading source files, planning, implementing, and verifying the solution.
Inputs & outputs
When to use schema-design
- →Designing a new database table
- →Defining schema for a domain entity
- →Refactoring database models
About this skill
Schema Design
Design a PostgreSQL schema for a new domain entity.
Steps
- Understand the context from
$ARGUMENTS - Read relevant source files
- Plan the approach
- Implement the solution
- Verify with tests
Resources
- See reference.md for patterns and examples
- See checklist.md for completion criteria
How it compares
This skill follows a structured five-step process for schema design, unlike an ad-hoc or manual approach.
Compared to similar skills
schema-design side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| schema-design (this skill) | 0 | 4mo | No flags | Beginner |
| drizzle-orm | 32 | 2mo | No flags | Intermediate |
| database-design | 6 | 6mo | Review | Intermediate |
| database-schema-designer | 6 | 6mo | No flags | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
You might also like
drizzle-orm
EpicenterHQ
Drizzle ORM patterns for type branding and custom types. Use when working with Drizzle column definitions, branded types, or custom type conversions.
database-design
davila7
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
database-schema-designer
davila7
Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.
database-migrations-sql-migrations
sickn33
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server
postgresql-syntax-reference
pgschema
Consult PostgreSQL's parser and grammar (gram.y) to understand SQL syntax, DDL statement structure, and parsing rules when implementing pgschema features
databases
mrgoonie
Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queries and aggregations, optimizing indexes for performance, performing database migrations, configuring replication and sharding, implementing backup and restore strategies, managing database users and permissions, analyzing query performance, or administering production databases.