🐘
DataPython

PostgreSQL Table Design

by timescale

PostgreSQL Table Design is a Data skill for Claude Code, published by timescale in pg-aiguide.

1.8K stars104 forkson timescale/pg-aiguideAdded 2026/08/18Repository updated 2026/06/26
View source on GitHubDownload repo ZIP
aiai-agentsai-codingclaude-code-pluginclaude-code-pluginsclaude-code-plugins-marketplaceclaude-marketplaceclaude-pluginclaude-skillsdocsdocumentationmcpmcp-serverpostgrespostgresqlskills
Install in seconds
Install PostgreSQL Table Design
Copy PostgreSQL Table Design into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.
terminal
npx degit https://github.com/timescale/pg-aiguide/tree/main/skills/design-postgres-tables ~/.claude/skills/design-postgres-tables

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/timescale/pg-aiguide.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file
skills/design-postgres-tables/SKILL.md in timescale/pg-aiguide
Installs to
~/.claude/skills/design-postgres-tables
Collection
One of 10 skills cataloged from this repository
Category
Data — 668 skills

What PostgreSQL Table Design does

PostgreSQL Table Design guides PostgreSQL schema, table, data type, constraint, and index decisions when creating new tables or modifying existing ones.

PostgreSQL Table Design is cataloged under Data on DirSkills. PostgreSQL Table Design comes from a repository tagged ai, ai-agents, ai-coding, claude-code-plugin and claude-code-plugins.

Frequently asked about PostgreSQL Table Design

  • What else does timescale publish alongside PostgreSQL Table Design?

    PostgreSQL Table Design is one of 10 skills that DirSkills catalogs from timescale/pg-aiguide, the repository it ships in. Its siblings there include Find Hypertable Candidates, Ghost Database and PGVector Semantic Search. Each one is a separate skill with its own page in this directory, installs the same way PostgreSQL Table Design does, and is maintained by timescale in that same repository. The rest of the collection is listed on the timescale/pg-aiguide page.

  • How does PostgreSQL Table Design compare to other Data skills?

    PostgreSQL Table Design ranks #358 by stars among the 668 Data skills in this catalog. The most-starred ones next to it are Benchmark Methodology, Jupyter Notebook and Solana. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of PostgreSQL Table Design against them. Open each page to compare what they document and how they install.

More from timescale/pg-aiguide

PostgreSQL Table Design is one of 10 skills cataloged on DirSkills from timescale/pg-aiguide.

See all 10 skills →
🗄️
2w ago

Find Hypertable Candidates

Find Hypertable Candidates analyzes an existing PostgreSQL database to identify which tables should be converted to Timescale/TimescaleDB hypertables. Use it when auditing tables for time-series or insert-heavy workloads and evaluating hypertable candidacy before migration.
DevOps
1.8K104
🐘
2w ago

Ghost Database

Ghost Database creates and manages PostgreSQL databases for agent workflows, with on-demand creation, instant forks for safe testing, and shareable snapshots. Use it when an agent needs persistent storage or wants to pass databases as assets between workflows.
DevOps
1.8K104
🔍
2w ago

PGVector Semantic Search

PGVector Semantic Search stores and searches vector embeddings in PostgreSQL using HNSW or IVFFlat indexes for semantic search, RAG, and nearest-neighbor queries. Use it to set up pgvector, tune recall and performance, or implement binary quantization for large datasets.
AI Engineering
1.8K104
🗺️
2w ago

PostGIS Spatial Table Design

PostGIS Spatial Table Design provides best practices and SQL patterns for designing PostGIS tables, covering geometry types, SRID selection, spatial indexes, and performance considerations for location-based applications.
Data
1.8K104
🐘
2w ago

PostgreSQL

PostgreSQL provides expert guidance for PostgreSQL table design, indexing, data types, constraints, extensions, search, and migrations. Use it when designing schemas, working with pgvector/PostGIS/TimescaleDB, or planning safe schema changes.
Data
1.8K104
🐘
2w ago

PostgreSQL Database Migration

PostgreSQL Database Migration helps plan, test, and safely execute PostgreSQL schema migrations on production data. Use it to understand DDL lock levels, perform zero-downtime ALTER TABLE changes, backfill data, and plan rollbacks.
DevOps
1.8K104

More Data skills

PostgreSQL Table Design is one of 668 Data skills cataloged on DirSkills, ranked #358 by stars among them.

Browse all Data skills →
📊
3w ago

Benchmark Methodology

Benchmark Methodology scores competitors across nine weighted dimensions using explicit 1–5 rubrics and a tension plot. Use it after competitive-platform-analysis to produce comparable, evidence-anchored profile cards for a competitive report.
Data
239.8K36.4K
📓
3w ago

Jupyter Notebook

Jupyter Notebook provides a stateful Python REPL via a live Jupyter kernel (hamelnb) so variables persist across executions. Use it for iterative data exploration, API inspection, and complex code development.
Data
229.7K45.3K
🪙
3w ago

Solana

Solana queries wallets, token holdings, transactions, NFTs, whale transfers, and network stats on the Solana blockchain with USD pricing via CoinGecko. Use it when you need to inspect an address, verify a transaction, check token metadata or prices, or monitor network health.
Data
229.7K45.3K