AI for Developers
Agent skill (SKILL.md) Open source Apache-2.0 1.8k

pg-aiguide

Gives your agent versioned PostgreSQL knowledge so it writes better schemas.

Install

Install
$ claude plugin marketplace add timescale/pg-aiguide claude plugin install pg@aiguide
Or with the skills CLI
$ npx skills add timescale/pg-aiguide -a claude-code
For every project
$ npx skills add timescale/pg-aiguide -a claude-code -g

Or copy the skill folder into .claude/skills/ (project) or ~/.claude/skills/ (all projects).

For this project
$ npx skills add timescale/pg-aiguide -a codex
For every project
$ npx skills add timescale/pg-aiguide -a codex -g

Or copy the skill folder into .agents/skills/ (project) or ~/.agents/skills/ (all projects).

For this project
$ npx skills add timescale/pg-aiguide -a cursor
For every project
$ npx skills add timescale/pg-aiguide -a cursor -g

Or copy the skill folder into .agents/skills/ (project) or ~/.cursor/skills/ (all projects).

For this project
$ npx skills add timescale/pg-aiguide -a gemini-cli
For every project
$ npx skills add timescale/pg-aiguide -a gemini-cli -g

Or copy the skill folder into .agents/skills/ (project) or ~/.gemini/skills/ (all projects).

For this project
$ npx skills add timescale/pg-aiguide -a opencode
For every project
$ npx skills add timescale/pg-aiguide -a opencode -g

Or copy the skill folder into .agents/skills/ (project) or ~/.config/opencode/skills/ (all projects).

For this project
$ npx skills add timescale/pg-aiguide -a windsurf
For every project
$ npx skills add timescale/pg-aiguide -a windsurf -g

Or copy the skill folder into .windsurf/skills/ (project) or ~/.codeium/windsurf/skills/ (all projects).

For this project
$ npx skills add timescale/pg-aiguide -a goose
For every project
$ 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

All skills