PostgreSQL

PostgreSQL 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

aiai-agentsai-codingclaude-code-pluginclaude-code-pluginsclaude-code-plugins-marketplaceclaude-marketplaceclaude-pluginclaude-skillsdocsdocumentationmcpmcp-serverpostgrespostgresqlskills

Install in seconds

Install PostgreSQL

Copy PostgreSQL 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/postgres ~/.claude/skills/postgres

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/postgres/SKILL.md in timescale/pg-aiguide
Installs to: ~/.claude/skills/postgres
Collection: One of 10 skills cataloged from this repository
Category: Data — 668 skills

What PostgreSQL does

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.

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

Documentation

README

Excerpt

design-postgres-tables — Data types, constraints, indexes, JSONB patterns, partitioning, and PostgreSQL best practices. Use for any general table/schema design task.
design-postgis-tables — PostGIS spatial table design: geometry vs geography types, SRIDs, spatial indexing, and location-based query patterns. Use when the task involves geographic or spatial data.

This is the opening of the README. Read the full README on GitHub.

Frequently asked about PostgreSQL

What else does timescale publish alongside PostgreSQL?
PostgreSQL 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 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 compare to other Data skills?
PostgreSQL ranks #357 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 against them. Open each page to compare what they document and how they install.