# pg-aiguide Skills > Postgres best practices for your agent: table design, indexes, pgvector and hybrid search, PostGIS and TimescaleDB hypertables. pg-aiguide Skills are Tiger Data's curated PostgreSQL best practices, packaged as Agent Skills so your coding agent writes better Postgres: tables with the right types, constraints and indexes, plus guidance for pgvector, PostGIS and TimescaleDB. Tiger Data, the maker of TimescaleDB, publishes them in its open-source pg-aiguide repository. What the skills teach your agent - postgres: one entry point that loads the right guide for the task, including safe schema migrations on production databases - design-postgres-tables: data types, constraints, indexes, JSONB patterns and partitioning - schema-exploration: read-only exploration of an existing database through pg_catalog, asking before it looks at any rows or statistics - design-postgis-tables: geometry or geography, coordinate systems (SRIDs) and spatial indexes - pgvector-semantic-search: storing embeddings, HNSW indexes, quantization and filtered vector search - postgres-hybrid-text-search: BM25 keyword search combined with vector search using Reciprocal Rank Fusion - setup-timescaledb-hypertables: hypertables, compression, retention policies and continuous aggregates - find-hypertable-candidates and migrate-postgres-tables-to-hypertables: score existing tables for conversion, then migrate and validate them How it installs - Add them all with npx skills add timescale/pg-aiguide, or one at a time, such as --skill postgres or --skill schema-exploration. - The skills are instructions and SQL patterns. They don't connect to a database on their own; your agent uses whatever database access you've already given it. Good to know - Tiger Data also runs a public pg-aiguide MCP server at https://mcp.tigerdata.com/docs for semantic search across the PostgreSQL, TimescaleDB and PostGIS manuals. - The README documents Claude Code, Cursor, Codex and Gemini CLI. - Open source under the Apache 2.0 license. - Type: Skill - Made by: timescale - Category: Databases - Formats: Skills - Version: latest - Website: https://github.com/timescale/pg-aiguide - Source: https://github.com/timescale/pg-aiguide - Page: https://pluginboard.ai/skills/pg-aiguide-skills ## Works with - ChatGPT - Claude - Gemini - GitHub Copilot - Cursor - Claude Code - Codex - Antigravity - Gemini CLI - Replit - OpenClaw - OpenCode - Hermes Agent ## Install ### ChatGPT In ChatGPT: Download the pg-aiguide folder and zip it, then Plugins → Skills → Create → Upload from your computer. Business and Enterprise plans. View the skills on GitHub: https://github.com/timescale/pg-aiguide ### Claude In Claude (web or desktop): Download each skill’s folder and zip it, then upload them one at a time in Customize → Skills. View the skills on GitHub: https://github.com/timescale/pg-aiguide ### Gemini In Gemini: Download the pg-aiguide folder, then at gemini.google.com click Customize → Skills → Create → Upload and pick the folder (or a .zip of it). View the skills on GitHub: https://github.com/timescale/pg-aiguide ### GitHub Copilot Copy all 9 skills, in your terminal: ```shell npx -y degit timescale/pg-aiguide/skills/design-postgis-tables ~/.copilot/skills/design-postgis-tables npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.copilot/skills/design-postgres-tables npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.copilot/skills/find-hypertable-candidates npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.copilot/skills/migrate-postgres-tables-to-hypertables npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.copilot/skills/pgvector-semantic-search npx -y degit timescale/pg-aiguide/skills/postgres ~/.copilot/skills/postgres npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.copilot/skills/postgres-hybrid-text-search npx -y degit timescale/pg-aiguide/skills/schema-exploration ~/.copilot/skills/schema-exploration npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.copilot/skills/setup-timescaledb-hypertables ``` View the skills on GitHub: https://github.com/timescale/pg-aiguide ### Cursor Copy all 9 skills, in your terminal: ```shell npx -y degit timescale/pg-aiguide/skills/design-postgis-tables ~/.cursor/skills/design-postgis-tables npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.cursor/skills/design-postgres-tables npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.cursor/skills/find-hypertable-candidates npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.cursor/skills/migrate-postgres-tables-to-hypertables npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.cursor/skills/pgvector-semantic-search npx -y degit timescale/pg-aiguide/skills/postgres ~/.cursor/skills/postgres npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.cursor/skills/postgres-hybrid-text-search npx -y degit timescale/pg-aiguide/skills/schema-exploration ~/.cursor/skills/schema-exploration npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.cursor/skills/setup-timescaledb-hypertables ``` View the skills on GitHub: https://github.com/timescale/pg-aiguide ### Claude Code Copy all 9 skills, in your terminal: ```shell npx -y degit timescale/pg-aiguide/skills/design-postgis-tables ~/.claude/skills/design-postgis-tables npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.claude/skills/design-postgres-tables npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.claude/skills/find-hypertable-candidates npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.claude/skills/migrate-postgres-tables-to-hypertables npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.claude/skills/pgvector-semantic-search npx -y degit timescale/pg-aiguide/skills/postgres ~/.claude/skills/postgres npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.claude/skills/postgres-hybrid-text-search npx -y degit timescale/pg-aiguide/skills/schema-exploration ~/.claude/skills/schema-exploration npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.claude/skills/setup-timescaledb-hypertables ``` View the skills on GitHub: https://github.com/timescale/pg-aiguide ### Codex Copy all 9 skills, in your terminal: ```shell npx -y degit timescale/pg-aiguide/skills/design-postgis-tables ~/.agents/skills/design-postgis-tables npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.agents/skills/design-postgres-tables npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.agents/skills/find-hypertable-candidates npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.agents/skills/migrate-postgres-tables-to-hypertables npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.agents/skills/pgvector-semantic-search npx -y degit timescale/pg-aiguide/skills/postgres ~/.agents/skills/postgres npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.agents/skills/postgres-hybrid-text-search npx -y degit timescale/pg-aiguide/skills/schema-exploration ~/.agents/skills/schema-exploration npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.agents/skills/setup-timescaledb-hypertables ``` View the skills on GitHub: https://github.com/timescale/pg-aiguide ### Antigravity In Antigravity: Copy the pg-aiguide folder into ~/.gemini/config/skills (Antigravity app and IDE) or ~/.gemini/antigravity-cli/skills (Antigravity CLI). View the skills on GitHub: https://github.com/timescale/pg-aiguide ### Gemini CLI Copy all 9 skills, in your terminal: ```shell npx -y degit timescale/pg-aiguide/skills/design-postgis-tables ~/.gemini/skills/design-postgis-tables npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.gemini/skills/design-postgres-tables npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.gemini/skills/find-hypertable-candidates npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.gemini/skills/migrate-postgres-tables-to-hypertables npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.gemini/skills/pgvector-semantic-search npx -y degit timescale/pg-aiguide/skills/postgres ~/.gemini/skills/postgres npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.gemini/skills/postgres-hybrid-text-search npx -y degit timescale/pg-aiguide/skills/schema-exploration ~/.gemini/skills/schema-exploration npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.gemini/skills/setup-timescaledb-hypertables ``` View the skills on GitHub: https://github.com/timescale/pg-aiguide ### Replit Copy all 9 skills, in your terminal: ```shell npx -y degit timescale/pg-aiguide/skills/design-postgis-tables .agents/skills/design-postgis-tables npx -y degit timescale/pg-aiguide/skills/design-postgres-tables .agents/skills/design-postgres-tables npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates .agents/skills/find-hypertable-candidates npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables .agents/skills/migrate-postgres-tables-to-hypertables npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search .agents/skills/pgvector-semantic-search npx -y degit timescale/pg-aiguide/skills/postgres .agents/skills/postgres npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search .agents/skills/postgres-hybrid-text-search npx -y degit timescale/pg-aiguide/skills/schema-exploration .agents/skills/schema-exploration npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables .agents/skills/setup-timescaledb-hypertables ``` View the skills on GitHub: https://github.com/timescale/pg-aiguide ### OpenClaw Copy all 9 skills, in your terminal: ```shell npx -y degit timescale/pg-aiguide/skills/design-postgis-tables ~/.openclaw/skills/design-postgis-tables npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.openclaw/skills/design-postgres-tables npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.openclaw/skills/find-hypertable-candidates npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.openclaw/skills/migrate-postgres-tables-to-hypertables npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.openclaw/skills/pgvector-semantic-search npx -y degit timescale/pg-aiguide/skills/postgres ~/.openclaw/skills/postgres npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.openclaw/skills/postgres-hybrid-text-search npx -y degit timescale/pg-aiguide/skills/schema-exploration ~/.openclaw/skills/schema-exploration npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.openclaw/skills/setup-timescaledb-hypertables ``` View the skills on GitHub: https://github.com/timescale/pg-aiguide ### OpenCode Copy all 9 skills, in your terminal: ```shell npx -y degit timescale/pg-aiguide/skills/design-postgis-tables ~/.config/opencode/skills/design-postgis-tables npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.config/opencode/skills/design-postgres-tables npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.config/opencode/skills/find-hypertable-candidates npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.config/opencode/skills/migrate-postgres-tables-to-hypertables npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.config/opencode/skills/pgvector-semantic-search npx -y degit timescale/pg-aiguide/skills/postgres ~/.config/opencode/skills/postgres npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.config/opencode/skills/postgres-hybrid-text-search npx -y degit timescale/pg-aiguide/skills/schema-exploration ~/.config/opencode/skills/schema-exploration npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.config/opencode/skills/setup-timescaledb-hypertables ``` View the skills on GitHub: https://github.com/timescale/pg-aiguide ### Hermes Agent Copy all 9 skills, in your terminal: ```shell npx -y degit timescale/pg-aiguide/skills/design-postgis-tables ~/.hermes/skills/design-postgis-tables npx -y degit timescale/pg-aiguide/skills/design-postgres-tables ~/.hermes/skills/design-postgres-tables npx -y degit timescale/pg-aiguide/skills/find-hypertable-candidates ~/.hermes/skills/find-hypertable-candidates npx -y degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables ~/.hermes/skills/migrate-postgres-tables-to-hypertables npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.hermes/skills/pgvector-semantic-search npx -y degit timescale/pg-aiguide/skills/postgres ~/.hermes/skills/postgres npx -y degit timescale/pg-aiguide/skills/postgres-hybrid-text-search ~/.hermes/skills/postgres-hybrid-text-search npx -y degit timescale/pg-aiguide/skills/schema-exploration ~/.hermes/skills/schema-exploration npx -y degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables ~/.hermes/skills/setup-timescaledb-hypertables ``` View the skills on GitHub: https://github.com/timescale/pg-aiguide --- From Pluginboard (https://pluginboard.ai).