Skills
.Work. You
Rest

design-postgres-tables

Official

Design robust PostgreSQL tables and schemas.

Software Engineering#design#schema#PostgreSQL#constraints#indexes#normalization#tables
Authortimescale
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This skill helps engineers design robust PostgreSQL table schemas with appropriate data types, constraints, and indexes. It emphasizes normalization, proper referential integrity, and scalable access patterns to reduce maintenance and data anomalies.

Core Features & Use Cases

  • Guidance on selecting data types, constraints, and indexes for common OLTP and analytical workloads.
  • Best practices for normalization (3NF), primary/foreign keys, identity columns, partitioning, and JSONB patterns.
  • Real-world example: design a users and orders schema with proper foreign keys, constraints, and targeted indexing.

Quick Start

Ask the AI to design a normalized customers and orders schema with primary keys, foreign keys, and required indexes.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: design-postgres-tables
Download link: https://github.com/timescale/pg-aiguide/archive/main.zip#design-postgres-tables

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.