Postgresql Table Design
Skill Verified ActiveUse this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
To provide expert-level, actionable advice for creating robust, performant, and maintainable PostgreSQL database schemas, guiding users through best practices and potential pitfalls.
Features
- Detailed PostgreSQL data type recommendations
- Guidance on indexing, constraints, and partitioning
- Coverage of PostgreSQL-specific "gotchas" and advanced features
- Best practices for schema normalization and denormalization
- Includes practical SQL examples for common table designs
Use Cases
- Designing new PostgreSQL tables and schemas
- Reviewing and optimizing existing PostgreSQL schemas
- Understanding PostgreSQL data type nuances and recommendations
- Implementing efficient indexing and constraint strategies for PostgreSQL
Non-Goals
- Providing general SQL advice
- Automating schema creation or modification
- Covering non-PostgreSQL database systems
- Troubleshooting runtime query performance issues
Installation
First, add the marketplace
/plugin marketplace add wshobson/agents/plugin install database-design@claude-code-workflowsQuality Score
VerifiedTrust Signals
Similar Extensions
DBHub Database Query Guide
100Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.
Dsql
100Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
Azure Postgres Ts
100Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package. Use for PostgreSQL queries, connection pooling, transactions, and Microsoft Entra ID (passwordless) authentication. Triggers: "PostgreSQL", "postgres", "pg client", "node-postgres", "Azure PostgreSQL connection", "PostgreSQL TypeScript", "pg Pool", "passwordless postgres".
Sql Optimization
100Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.
Senior Backend Engineer
100Designs and implements backend systems including REST APIs, microservices, database architectures, authentication flows, and security hardening. Use when the user asks to "design REST APIs", "optimize database queries", "implement authentication", "build microservices", "review backend code", "set up GraphQL", "handle database migrations", or "load test APIs". Covers Node.js/Express/Fastify development, PostgreSQL optimization, API security, and backend architecture patterns.