pg-aiguide
Postgres skills and documentation to help AI coding tools generate better PostgreSQL code.
Ads
Overview
AI-optimized PostgreSQL expertise for coding assistants pg-aiguide helps AI coding tools write dramatically better PostgreSQL code. It provides: - Semantic search across the official PostgreSQL manual (version-aware) - AI-optimized “skills” — curated, opinionated Postgres best practices used automatically by AI agents - Extension ecosystem docs, starting with TimescaleDB, with more coming soon - Agent Skills via npx skills — works with Claude Code, Cursor, Codex, Gemini CLI, and 40+ other agents - a public MCP server that can be used with any AI coding agent, or - a Claude Code plugin optimized for use with Claude's native skill support.
Installation
npx skills add timescale/pg-aiguide --skill postgres
Configuration
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}Capabilities
- Search PostgreSQL docs semantically
ask the assistant to look up a feature or syntax across the official manual using `search_docs` with the `postgres` source.
- Search TimescaleDB docs
retrieve relevant TimescaleDB documentation by querying the `tiger` source through `search_docs`.
- Search PostGIS docs
find spatial extension guidance via `search_docs` scoped to the `postgis` source.
- Retrieve a curated best-practice skill
load opinionated PostgreSQL guidance on schema design, indexing, or data types with `view_skill`.
Tags
- documentation
- document
- database
Related MCP servers
InstantDB
OfficialCreate, manage, and update applications on InstantDB, the modern Firebase.
Jitsu
OfficialManage Jitsu data pipelines from your AI assistant — destinations, streams, connections, syncs, functions, and live events.
PostgreSQL MCP Server
OfficialRun read-only SQL queries and inspect PostgreSQL schemas from your MCP client.
Financial Datasets
OfficialStock market API made for AI agents