←Leaderboard/Databases/pg-aiguide
Last commit on October 7, 2026·Created on July 23, 2025

timescale/pg-aiguide

“Design and optimize PostgreSQL databases and queries.”
Combined rank
#273
across all skills
In Databases
#2
category rank
Stars
1.9k
0.0% in last 7d
Forks
120
+0.8% in last 7d
Watchers
12
0.0% in last 7d
Traction scoreGitHub stars can be faked, so popularity alone can be misleading. Traction Score looks for broader signs of recent attention, adoption, and active maintenance.
TL;DR

Combines opinionated Postgres skills with version-aware search of the official manual. The MCP route adds documentation retrieval, while the skill packages provide reusable guidance for schema and query work.

WHO IT'S FOR
Backend engineers
designing optimized PostgreSQL table schemas
AI / ML engineers
implementing semantic and hybrid search
GIS developers
designing spatial tables with PostGIS
Database administrators
migrating workloads to TimescaleDB hypertables

Use this skill collection

Follow the documented setup, then try a first task.

I’m using

Claude Code pg plugin

Installs: The complete pg@aiguide plugin, including the repository's skills bundle and the public PostgreSQL documentation MCP server. The listed skill paths are a bounded selection. · Claude Code

Before you start
  • Claude Code available in the terminal.
  1. Run both commands in your terminal, in order, to add the marketplace and install its pg plugin.

    claude plugin marketplace add timescale/pg-aiguide
    claude plugin install pg@aiguide
skills/pgvector-semantic-search/SKILL.md ↗ · Checked Nov 14, 2026skills/schema-exploration/SKILL.md ↗ · Checked Nov 14, 2026README.md ↗ · Checked Nov 14, 2026.claude-plugin/marketplace.json ↗ · Checked Nov 14, 2026skills/design-postgres-tables/SKILL.md ↗ · Checked Nov 14, 2026

Give it something to do.

Suggested first task

Draft users and orders tables

Uses design-postgres-tables

  • Target PostgreSQL version.
  • Required user and order fields, business constraints, and common queries.
Use the design-postgres-tables skill to draft PostgreSQL users and orders tables for a small application. Use my supplied fields and access patterns to choose data types, primary and foreign keys, required constraints, and indexes. Explain the main choices and return SQL for review without executing it.
Suggested first task

Understand one database relationship

Uses schema-exploration

  • One business concept or focused relationship question.
  • Provided schema files or an available authorized PostgreSQL connection.
  • Authorized database and schema scope.
Use the schema-exploration skill to identify the tables representing one business concept I specify and explain their relevant keys and relationships. Work from my provided schema files or the authorized database connection, using structural catalog metadata only. Report schema-qualified objects, distinguish verified facts from inferred meaning, and stop once this question is answered.
Suggested first task

Draft a default semantic-search setup

Uses pgvector-semantic-search

  • PostgreSQL 15+ with pgvector 0.8.0+ available.
  • Embedding dimension and the model used consistently for stored and query embeddings.
  • Document fields to retain alongside embeddings.
Use the pgvector-semantic-search skill to draft a minimal setup for storing document text with embeddings and retrieving the five nearest matches. Use the default halfvec storage, cosine distance, and HNSW configuration, adapting every dimension to my embedding dimension. Include a parameterized query with an explicit vector cast and briefly explain the index and recall settings. Return SQL for review without executing it.