timescale

    timescale/pg-aiguide

    MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

    ai
    ai-agents
    documentation
    database
    ai-coding
    claude-code-plugin
    claude-code-plugins
    claude-code-plugins-marketplace
    claude-marketplace
    Python
    Apache-2.0
    1.9K stars
    120 forks
    1.9K GitHub watchers
    Updated Nov 2, 2026
    View on GitHub

    Build with Backblaze B2

    SDKs, agent skills, IDE extensions, and reference pipelines from Backblaze Labs. All open source.

    Explore Backblaze Labs

    Loading star history...

    Where it stands

    Rank, growth pace and release cadence relative to everything GStars tracks.

    2 releases in the last 90 days, the latest 60 days ago, with 18 contributors on GitHub.

    Gained 21% fewer stars in the last 90 days than in the 90 days before.

    Use Cases & Benefits

    • Provides AI coding tools with version-aware PostgreSQL documentation and best-practice skills to generate high-quality Postgres code.
    • Delivers curated, opinionated Postgres expertise that ensures modern, robust, and performant database schemas beyond generic AI outputs.
    • Use for enhancing AI assistants to write accurate, constraint-rich, and index-optimized PostgreSQL schemas automatically.
    • Use for integrating semantic search of official Postgres and TimescaleDB docs into AI coding workflows for precise query and schema guidance.
    • Use for extending AI coding plugins like Claude Code with expert PostgreSQL skills to improve code quality and maintainability.

    Should you depend on it?

    License terms, project hygiene and risks, from GitHub metadata and GStars' snapshots.

    License

    Apache 2.0

    Permissive: commercial use, modification and redistribution are allowed with attribution; includes an explicit patent grant from contributors.

    Community files

    • README: present

    Watch-outs

    No watch-outs from GStars' checks.

    General guidance from repository metadata, not legal advice. How we score

    From the README

    AI-optimized PostgreSQL expertise for coding assistants

    AI coding tools often generate Postgres code that is:

    pg-aiguide fixes that by giving AI agents deep, versioned PostgreSQL knowledge and proven patterns.

    Excerpt from the timescale/pg-aiguide README on GitHub (Apache-2.0 license). © its authors.Read the full README on GitHub

    Daily snapshots

    Stars gained per day, and how forks and open issues moved, from GStars' daily snapshots

    Forks

    120+17

    Open issues

    20-14

    Compared with peers in AI

    Fastest-growing repositories GStars tracks in this cohort for the week of Nov 1, by 7-day star growth

    timescale/pg-aiguide compared with AI repositories by stars, 7-day star growth, health score and last release
    RepositoryStars+7dHealthLast release
    thedotmack/claude-mem113.6K+8.8K35today
    D4Vinci/Scrapling98.1K+6.9K651 day ago
    Leonxlnx/taste-skill110.7K+5.2K551 day ago
    calesthio/OpenMontage77.2K+4.2K40—
    heygen-com/hyperframes79.6K+4.1K45today
    timescale/pg-aiguide1.9K—3360 days ago
    Category median98.1K+5.2K45—

    Also by timescale

    Other repositories from this maintainer that GStars tracks

    Discover Repositories

    Search across tracked repositories by name or description