AgentIndex icon
AgentIndex
ToolsMCP ServersHOTCategoriesTrendingNewBest ListsCompareGuides
Submit Tool
ToolsMCP ServersHOTCategoriesTrendingNewBest ListsCompareGuides
Home/
Code Assistant/
pg-aiguide
pg-aiguide logo

pg-aiguide

Active·★ 1.9k·Apache-2.0·Updated 2026-11-09

pg-aiguide aims to make AI coding tools write better PostgreSQL. The README says assistants often produce outdated SQL, miss constraints and indexes and ignore modern Postgres features, and offers three things: semantic search over the official PostgreSQL manual that is scoped to a version, curated and opinionated best-practice skills, and documentation for extensions, starting with TimescaleDB (pgvector and PostGIS are listed as coming soon). The skills cover schema design, indexing, data types, constraints, naming conventions, performance tuning and modern features.

It can be used as a public MCP server at `https://mcp.tigerdata.com/docs`, which any MCP client can add with a URL, or as a Claude Code plugin with `claude plugin marketplace add timescale/pg-aiguide` and `claude plugin install pg@aiguide`. One-click installs are listed for Cursor, VS Code, Goose and LM Studio. The tools are `semantic_search_postgres_docs`, `semantic_search_tiger_docs` and `view_skill`. The README includes a before-and-after demo of an e-commerce schema generated with and without the server, which is the project's own example. It is Apache 2.0 licensed.

This write-up is based on the project's README and public repository data. We have not hand-tested the tool. Data as of 2026-11-08.

License
Apache-2.0
Latest release
v0.6.1 · 2026-09-04
Last commit
2026-11-08
Contributors
20
Forks
119
Open issues and PRs
19
First published
2025-07-23

Source: GitHub, npm and PyPI public APIs.

#PostgreSQL#AI Assistant#Code Generation#Database Schema#Best Practices#Semantic Search#TimescaleDB#Developer Tools
$ Install
$ claude plugin marketplace add timescale/pg-aiguide && claude plugin install pg@aiguide
↗ Visit site★ GitHub
01

Features

01Performs semantic search across the official PostgreSQL manual, with results scoped to a specific Postgres version.
02Provides AI-optimized "skills" that offer curated, opinionated PostgreSQL best practices for AI agents.
03Supports documentation for the PostgreSQL extension ecosystem, starting with TimescaleDB.
04Improves AI-generated database schemas with more constraints, indexes, and modern PostgreSQL features.
05Offers guidance on schema design, indexing strategies, data types, and performance tuning.
02

Why choose it

+Version-aware semantic search over the official PostgreSQL manual
+Curated best-practice skills for schema design, indexing, constraints and performance
+Connect with just a URL, or install as a Claude Code plugin
+One-click installs for Cursor, VS Code, Goose and LM Studio
03

Trade-offs

!The default setup uses a public hosted MCP server, so queries go to an external service
!Extension coverage is limited: TimescaleDB today, with pgvector and PostGIS listed as coming soon
!The skills are opinionated, so they reflect one team's view of best practice
!The before-and-after demo is the project's own example, not an independent benchmark
05

Maintenance check

ActiveChecked: 2026-11-06
Last commit
2026-11-06
Commits, last 90 days
38
Releases, last 90 days
2
Latest release
v0.6.1 (2026-09-04)
Open issues
15
Recent issues with at least one comment
0/6
Commits per week, last 12 weeks
Commits per week, last 12 weeks: 0, 0, 14, 2, 1, 7, 0, 1, 0, 3, 0, 10

Oldest week on the left; the latest four weeks are orange. Source: GitHub commit activity.

Status rule: archived on GitHub = Archived; last commit within 90 days = Active; 91 to 365 days = Slowing; older = Stale. All figures come from the GitHub API on the date shown.

Most discussed open issues

  • #184 Dependency Dashboard0 comments · 2026-11-06
  • #175 search_docs REST endpoint rejects semanticWeight from the query string0 comments · 2026-10-25
  • #174 Documentation and example corrections in timescale/pg-aiguide0 comments · 2026-10-24
  • #128 Make Type-Conversion Validation Exact and NULL-Safe0 comments · 2026-07-19
  • #127 Prevent Resumable Backfills From Stopping at Sparse or Prefilled IDs0 comments · 2026-07-19

Issue titles are quoted from GitHub. Open the link to check whether a problem still applies to the version you use.

04

Who it fits

Pick it if
  • You want your coding assistant to write better PostgreSQL: version-aware search over the official manual plus best-practice skills for schema, indexing and constraints.
  • You use TimescaleDB and want its docs available to the assistant.
  • You want to connect with a URL (mcp.tigerdata.com/docs) or install as a Claude Code plugin.
Look elsewhere if
  • You want an assistant to query your own database: this serves documentation and skills, not database access.
  • You do not want queries sent to a hosted service; the default setup uses a public hosted MCP server.
  • You need extension docs beyond TimescaleDB today; pgvector and PostGIS are listed as coming soon.
06

How it differs

dbhub logovs dbhub★ 3.8k

They solve different problems and can be used together. DBHub gives an agent access to live databases; pg-aiguide gives it Postgres knowledge so the SQL it writes is better.

Full comparison →
07

Compatibility

AI Coding Agents
Target Audience
Verified via docs
Claude Code
Plugin
Verified via docs
Cursor
IDE Integration
Verified via docs
VS Code
IDE Integration
Verified via docs
VS Code Insiders
IDE Integration
Verified via docs
Visual Studio
IDE Integration
Verified via docs
08

Quick start

1
$ claude plugin marketplace add timescale/pg-aiguide
2
$ claude plugin install pg@aiguide
09

Use cases

↳Improving the quality and robustness of PostgreSQL code generated by AI coding assistants.
↳Designing optimal and performant PostgreSQL database schemas with AI assistance.
↳Accessing version-aware PostgreSQL documentation and best practices via AI semantic search.
↳Integrating advanced PostgreSQL expertise into various AI coding agents and IDEs.
↳Leveraging modern PostgreSQL features and best practices in AI-assisted development for better data integrity and performance.
10

Alternatives

⚡Top VS:
VSdbhub★3.8k→VSchunkhound★1.5k→VSContext7★64.4k→VSgptme★4.5k→
dbhub logo
dbhub★ 3.8k
Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
VSCompare→
chunkhound logo
chunkhound★ 1.5k
Local first codebase intelligence
VSCompare→
Context7 logo
Context7★ 64.4k
MCP Server that provides up-to-date code documentation for LLMs and AI code editors.
VSCompare→
awesome-vibe-coding logo
awesome-vibe-coding★ 5.4k
A curated list of vibe coding references, collaborating with AI to write code.
gptme logo
gptme★ 4.5k
Your agent in your terminal, equipped with local tools: writes code, uses the terminal, browses the web, vision.
VSCompare→
refact logo
refact★ 3.5k
AI Agent that handles engineering tasks end-to-end: integrates with developers’ tools, plans, executes, and iterates until it achieves a successful result.
VSCompare→
boost logo
boost★ 3.7k
Laravel-focused MCP server for augmenting your AI powered local development experience.
VSCompare→
specmem logo
specmem★ 0
SpecMem - TRUE Semantic Memory for Claude Code - Runs locally - Remembers your code base - Per-project isolation, semantic search, team coordination. https://justcalljon.pro
See all alternatives →

Featured in these lists

  • Best MCP Servers for Databases
  • Best MCP Servers for Up-to-Date Docs and Code Context

Comments

Log in to leave a comment

No comments yet. Be the first!

On this page
01Features02Why choose it03Trade-offs05Maintenance check04Who it fits06How it differs07Compatibility08Quick start09Use cases10Alternatives
timescale /
pg-aiguide
↗

PostgreSQL docs and best-practice skills for AI coding assistants

1.9k119Apache-2.0
Last commit2d ago
StatusActive
CategoryCode Assistant
Contributors20
Latest releasev0.6.1
Links
Documentation↗Discussion↗Issues↗Releases↗
Cloud Infrastructure
Ad

Deploy on DigitalOcean

Host your MCP servers, Docker containers, and AI agents with $200 free credit over 60 days.

Claim $200 Free Credit
© 2026 AgentIndex.app|Built by a 10-year iOS Developer.
Best by use caseAboutContactAdvertisePrivacy PolicyTerms of UseQYSGitHubBuy me a coffee ☕

Browse by Category

MCP ServersCode AssistantWorkflow AutomationRAG / Knowledge BaseMulti-AgentBrowser AutomationLLM InfraDev ToolingObservability

Not affiliated with Anthropic, OpenAI or Microsoft.