pg-aiguide
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
pg-aiguide is an MCP server and agent skill collection that provides AI coding assistants with deep PostgreSQL expertise. It offers semantic search across official PostgreSQL, TimescaleDB, and PostGIS documentation, plus curated best-practice skills that guide AI agents to generate modern, robust database schemas. The tool integrates as an MCP server, agent skills via npx, or a Claude Code plugin, helping AI assistants produce code with better constraints, indexes, and PostgreSQL 17 features. Benchmark tests show schemas generated with pg-aiguide include 4× more constraints and 55% more indexes compared to unassisted AI outputs.
Key Features
Use Cases
- 01Generating production-ready database schemas with proper constraints and indexes for e-commerce, IoT, or SaaS applications
- 02Teaching AI assistants PostgreSQL best practices for schema design and query optimization
- 03Looking up version-specific PostgreSQL syntax and features during AI-assisted development
- 04Ensuring AI-generated TimescaleDB time-series schemas follow recommended patterns
- 05Reviewing and improving existing database designs with AI assistance informed by PostgreSQL documentation
- 06Building spatial data applications with PostGIS guidance integrated into AI coding tools
Related MCP Servers
View moremarkitdown
Python tool for converting files and office documents to Markdown.
firecrawl
The context API to search, scrape, and interact with the web at scale. 🔥
prompts.chat
f.k.a. Awesome ChatGPT Prompts. Share, discover, and collect prompts from the community. Free and open source — self-host for your organization with complete privacy.
langflow
Langflow is a powerful tool for building and deploying AI-powered agents and workflows.
pg-aiguide — FAQ
What is pg-aiguide?+
pg-aiguide is an MCP server and skill collection that gives AI coding assistants access to PostgreSQL documentation and curated best practices. It helps AI tools generate modern, performant database schemas with proper constraints, indexes, and PostgreSQL 17 features.
How do I install pg-aiguide as an MCP server?+
Add the public server URL https://mcp.tigerdata.com/docs to your AI client's MCP configuration JSON, or use one-click install buttons for Cursor, VS Code, Visual Studio, and other supported clients. No local installation or API keys are required.
Which AI clients work with pg-aiguide?+
pg-aiguide works with Claude Code, Cursor, Codex, Gemini CLI, VS Code, Visual Studio, Windsurf, OpenCode, Goose, LM Studio, and 40+ other MCP-compatible AI coding assistants. Skills can be added via npx to any agent supporting the agent skills protocol.
Do I need API keys or a PostgreSQL database to use pg-aiguide?+
No API keys or database connection are required. pg-aiguide provides documentation search and best-practice guidance only; it does not connect to or query actual PostgreSQL databases.
Is pg-aiguide free to use?+
Yes, pg-aiguide is open source under the Apache 2.0 license and the public MCP server endpoint is freely available. The project is maintained by Timescale.
How do I install pg-aiguide as a Claude Code plugin?+
Run 'claude plugin marketplace add timescale/pg-aiguide' followed by 'claude plugin install pg@aiguide' in your terminal. This installs both the skills and connects to the MCP documentation server.
How do I install pg-aiguide?+
Open the source repository on GitHub and follow its README. pg-aiguide is a mcp server — MCP Agents Market links you directly to the official repo.
Is pg-aiguide free?+
pg-aiguide is an open-source project hosted on GitHub. Check the repository for its license and any usage requirements.