Loading listing…
design-postgres-tables
Security scan passedUse this skill for general PostgreSQL table design.
Part of pg-aiguide SkillsPack · 9 skills
by timescale· DatabasesUnclaimed · Yours? Claim it
What design-postgres-tables does
About
Use this skill for general PostgreSQL table design. **Trigger when user asks to:** - Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones. - Choose data types, constraints, or indexes for PostgreSQL - Create user tables, order tables, reference tables, or JSONB schemas - Understand PostgreSQL best practices for normalization, constraints, or indexing - Design update-heavy, upsert-heavy, or OLTP-style tables **Keywords:** PostgreSQL schema, table design, data types, PRIMARY KEY, FOREIGN KEY, indexes, B-tree, GIN, JSONB, constraints, normalization, identity columns, partitioning, row-level security Comprehensive reference covering data types, indexing strategies, constraints, JSONB patterns, partitioning, and PostgreSQL-specific best practices.
Install design-postgres-tables
More from Databases
Skills people install alongside design-postgres-tables.
