pg-aiguide
Gives your agent versioned PostgreSQL knowledge so it writes better schemas.
Install
claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide
npx skills add timescale/pg-aiguide -a claude-code
npx skills add timescale/pg-aiguide -a claude-code -g
Or copy the skill folder into .claude/skills/ (project) or ~/.claude/skills/ (all projects).
npx skills add timescale/pg-aiguide -a codex
npx skills add timescale/pg-aiguide -a codex -g
Or copy the skill folder into .agents/skills/ (project) or ~/.agents/skills/ (all projects).
npx skills add timescale/pg-aiguide -a cursor
npx skills add timescale/pg-aiguide -a cursor -g
Or copy the skill folder into .agents/skills/ (project) or ~/.cursor/skills/ (all projects).
npx skills add timescale/pg-aiguide -a gemini-cli
npx skills add timescale/pg-aiguide -a gemini-cli -g
Or copy the skill folder into .agents/skills/ (project) or ~/.gemini/skills/ (all projects).
npx skills add timescale/pg-aiguide -a opencode
npx skills add timescale/pg-aiguide -a opencode -g
Or copy the skill folder into .agents/skills/ (project) or ~/.config/opencode/skills/ (all projects).
npx skills add timescale/pg-aiguide -a windsurf
npx skills add timescale/pg-aiguide -a windsurf -g
Or copy the skill folder into .windsurf/skills/ (project) or ~/.codeium/windsurf/skills/ (all projects).
npx skills add timescale/pg-aiguide -a goose
npx skills add timescale/pg-aiguide -a goose -g
Or copy the skill folder into .goose/skills/ (project) or ~/.config/goose/skills/ (all projects).
Run npx skills add timescale/pg-aiguide --skill postgres.
When to use
Use it when an agent designs schemas or writes queries, so it picks sensible data types, constraints and indexes for your Postgres version.
pg-aiguide gives coding agents versioned PostgreSQL knowledge. AI tools often generate Postgres code that is outdated, missing constraints and indexes, or unaware of modern features. It supplies curated best practices as skills, semantic search over the official PostgreSQL manual that is version aware, and docs for extensions, starting with TimescaleDB.
Use it as agent skills through npx skills, as a public MCP server for any agent, or as a Claude Code plugin. A second skill explores an existing database. The project comes from Timescale.
Related skills
-
rea
Lets your agent reverse engineer an app from the outside, down to native binaries, and then build its own version.
-
superpowers
A set of development habits for your agent: test first, debug systematically, and plan before you code.
-
skills
The skills Matt Pocock uses in his own day-to-day engineering work.
-
ECC
A ready-made setup for coding agents that adds skills, persistent memory and security checks.