Prototype · Preview: every server in the official registry, synced every 30 minutes. Sign in with Google to write reviews.Prototype · updated every 30 min
PopNx MCPMCP servers for people who use AI · explained in plain words

pg-aiguide Skill

Repository ↗

Also available as an MCP server →

by timescale★ 1,886 (whole repo)10 skills

★ Stars are for the whole repo, not each skill

Pick the skill to install

What it does

This repo is a collection of 10 skills

  • Connects Instruction files the AI reads, with steps that call an outside service
  • Account or key Some steps need a key for OpenAI, OPENROUTER_API_KEY (per the README)
  • Category Coding
Maker’s original description
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
For makers: add a badge to your README

If you made this, paste this code into your README. The badge links back to this page.

[![Featured on PopNx MCP](https://mcp.popnx.com/badge/skill/timescale-pg-aiguide.svg)](https://mcp.popnx.com/en/skills/timescale-pg-aiguide)

Use together with

MCP servers that connect the AI to services for the same work

REA

Reverse engineer anything from your terminal or agent with one CLI and MCP server.

by morlutoWidely used↓ 388.7K/wk★ 466.2KUpdated 6 days ago

MCP · Connects a serviceRuns on your computer

Fallow

Codebase intelligence for TypeScript and JavaScript, exposed as structured MCP analysis tools.

by fallow-rsWidely used↓ 2.4M/wk★ 5.4KUpdated yesterday

MCP · Connects a serviceRuns on your computer

Desktop Commander

MCP server for terminal commands, file operations, and process management

by wonderwhy-erWidely used↓ 740.3K/wk★ 10.3KUpdated 6 days ago

MCP · Connects a serviceRuns on your computer

Similar Skills

Same kind of work, ordered like the Skills list

Compared with similar ones
This one
pg-aiguide
reaandrej-karpathy-skillsgraphifyMoneyPrinterTurbo
Makertimescalemorlutomultica-aiGraphify-Labsharry0703
Skills101111
GitHub stars1,886465,460233,910149,364144,149
Last code changeNov 16, 2026Nov 17, 2026Apr 20, 2026Nov 17, 2026Nov 17, 2026
LicenseApache-2.0MIT–Apache-2.0MIT

10 skills (instruction sets) by timescale that an AI reads and follows · not an MCP server

Pick the skill to install

Install only the ones you use. Open a skill to see how to install it

Install the whole set (10)

If you want every one, let the AI install them in one go. Know 2 things first

  • Every installed skill’s description is loaded into every chat. The more you install, the easier it is for the AI to pick the wrong one
  • Some skills duplicate tools the AI already has built in. Installing only the ones you use works better
Where to install
Please install all 10 skills from https://github.com/timescale/pg-aiguide: design-postgis-tables, design-postgres-tables, find-hypertable-candidates, ghost-database, migrate-postgres-tables-to-hypertables, pgvector-semantic-search, postgres, postgres-database-migration, postgres-hybrid-text-search, setup-timescaledb-hypertables, for all my projects, putting each at ~/.claude/skills/<skill name> (in Codex use ~/.agents/skills/<skill name>, in Cursor ~/.cursor/skills/<skill name>). Folders in the repo: design-postgis-tables = skills/design-postgis-tables · design-postgres-tables = skills/design-postgres-tables · find-hypertable-candidates = skills/find-hypertable-candidates · ghost-database = skills/ghost-database · migrate-postgres-tables-to-hypertables = skills/migrate-postgres-tables-to-hypertables · pgvector-semantic-search = skills/pgvector-semantic-search · postgres = skills/postgres · postgres-database-migration = skills/postgres-database-migration · postgres-hybrid-text-search = skills/postgres-hybrid-text-search · setup-timescaledb-hypertables = skills/setup-timescaledb-hypertables. First show me every file and tell me whether any has scripts or changes machine settings, then tell me the full path you will install each one to and wait for me to agree.
Please install all 10 skills from https://github.com/timescale/pg-aiguide: design-postgis-tables, design-postgres-tables, find-hypertable-candidates, ghost-database, migrate-postgres-tables-to-hypertables, pgvector-semantic-search, postgres, postgres-database-migration, postgres-hybrid-text-search, setup-timescaledb-hypertables, into the project this chat is open in (at .claude/skills/<skill name>; in Codex use .agents/skills/<skill name>, in Cursor .cursor/skills/<skill name>). Folders in the repo: design-postgis-tables = skills/design-postgis-tables · design-postgres-tables = skills/design-postgres-tables · find-hypertable-candidates = skills/find-hypertable-candidates · ghost-database = skills/ghost-database · migrate-postgres-tables-to-hypertables = skills/migrate-postgres-tables-to-hypertables · pgvector-semantic-search = skills/pgvector-semantic-search · postgres = skills/postgres · postgres-database-migration = skills/postgres-database-migration · postgres-hybrid-text-search = skills/postgres-hybrid-text-search · setup-timescaledb-hypertables = skills/setup-timescaledb-hypertables. First show me every file and tell me whether any has scripts or changes machine settings, then tell me the project name and the full path you will install each one to and wait for me to agree.

Uploading to Claude on the web and apps: you need 10 uploads, one ZIP per skill. Open each skill in the list below to download it

Checked against official docs Nov 12, 2026 · Source: support.claude.com, code.claude.com, learn.chatgpt.com, cursor.com

  • design-postgis-tables

    Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications

  • design-postgres-tables

    Use this skill for general PostgreSQL table design. **Trigger when user asks to:** - Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones. - Choose data types, constraints, or indexes for PostgreSQL - Create user tables, order tables, reference…

  • find-hypertable-candidates

    Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. **Trigger when user asks to:** - Analyze database tables for hypertable conversion potential - Identify time-series or event tables in an existing schema - E…

  • ghost-database

    No description from the maker

  • migrate-postgres-tables-to-hypertables

    Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation. **Trigger when user asks to:** - Migrate or convert PostgreSQL tables to hypertables - Execute hypertable migration with minimal downtime - Plan blue-green migratio…

  • pgvector-semantic-search

    Use this skill for setting up vector similarity search with pgvector for AI/ML embeddings, RAG applications, or semantic search. **Trigger when user asks to:** - Store or search vector embeddings in PostgreSQL - Set up semantic search, similarity search, or nearest neighbor search - Create HNSW or…

  • postgres

    Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. **Trigger when user asks to:** - Explore an existing PostgreSQL database to understand its objects and relationships - Design or mo…

  • postgres-database-migration

    Use this skill for planning, testing, and safely executing PostgreSQL schema migrations — especially when working with production data or shared databases. **Trigger when user asks to:** - Test a schema migration before applying it to production - Add, remove, or rename columns safely on a live tab…

  • postgres-hybrid-text-search

    Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF). **Trigger when user asks to:** - Combine keyword and semantic search - Implement hybrid search or multi-modal retrieval - Use BM25/pg_textsearch with pgvector toge…

  • setup-timescaledb-hypertables

    Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics, events, or log data. Use this to improve the performance of any insert-heavy table. **Trigger when user asks to:** - Create or design SQL schemas/…

How a Skill differs from MCP

MCP = the hands

Connects the AI to an outside service or data, such as reading Notion or creating an invoice. A program or server has to be running.

Skill = the manual

A text file that teaches the AI how to do a task. It connects to nothing.

Some overlap: a few Skills run scripts that call tools, and a few MCP servers only send knowledge. Start from the task you want done.

Works with

Claude CodeCodexCursorGemini CLIWindsurfOpenCode

From the maker’s README and the folders in the repo

Install

Pick a skill first

This repo has 10 skills. Pick one from the list above; its page shows every way to install it, including letting the AI install it and a ZIP

Let the AI install it
Upload to claude.ai

Go to the skill list ↑

The maker’s command installs the whole set of 10
Install Node.js (if you don’t have it)

Already installed? Check first · Open Terminal, type this command and press Enter

node -v
  • A version number such as v26.13.1 = installed, skip this step
  • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
How to open Terminal

Mac: press ⌘ + Space, type Terminal, press Enter

Windows: open Start, type Windows PowerShell, then Open

Not installed: Open the official download page, pick the LTS version and the click-through installer: .pkg on Mac · .msi on Windows. Double-click and follow it to the end. No curl command needed

Open the Node.js download page ↗

When it’s done, close Terminal, open it again and run the same command. You should see a version number: node -v

Install once; it works for everything that needs Node.js

npx skills add timescale/pg-aiguide --skill postgres

Copied from the maker’s README; it downloads and runs the maker’s code

Discussion

Ask, share a tip or report that it does not work. Sorted by what people marked helpful.

No posts yet. Be the first to ask or share.

Posts here are written by users, not the PopNx team.

Sign in to post

From GitHub

GitHub stars
1,886
Stars are for the whole repo, not each skill
Maker
timescale
License
Apache-2.0
Last code change
Nov 16, 2026
SKILL.md files in the repo (including translated copies and templates)
10
Topics
ai, ai-agents, ai-coding, claude-code-plugin, claude-code-plugins, claude-code-plugins-marketplace, claude-marketplace, claude-plugin, claude-skills, docs, documentation, mcp