Postgres AI Guide
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
What is Postgres AI Guide?
Postgres AI Guide is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to mcp server and claude plugin for postgres skills and documentation. helps ai coding tools generate better postgresql code.
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- semantic_search_postgres_docs
- semantic_search_tiger_docs
- view_skill
Use Cases
Maintainer
Works with
Installation
NPM
npx -y @tigerdata/pg-aiguideManual Installation
npx -y @tigerdata/pg-aiguideConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Postgres AI Guide
pg-aiguide is an MCP server and AI agent skill that provides AI coding assistants with semantic search over PostgreSQL documentation, TimescaleDB extension docs, and PostGIS reference material, along with curated best-practice guidance for schema design, indexing, data types, constraints, naming conventions, and performance tuning. It connects to a hosted endpoint at mcp.tigerdata.com/docs and exposes two tools—search_docs and view_skill—that measurably improve the quality of AI-generated SQL: in benchmarks, schemas produced with pg-aiguide included 4× more constraints and 55% more indexes than those produced without it. SQL developers and AI-assisted engineering teams use pg-aiguide to prevent the outdated patterns and missing constraints that AI models commonly produce when writing PostgreSQL code.
Prerequisites
- Node.js 18+ with npx available, OR an MCP-compatible client that supports HTTP transport
- One of: Claude Code, Cursor, VS Code with the MCP extension, Gemini CLI, or another MCP-compatible tool
- No PostgreSQL installation required—pg-aiguide queries documentation, not a live database
- Internet access to reach the hosted MCP endpoint at https://mcp.tigerdata.com/docs
Add pg-aiguide to Claude Code
Install pg-aiguide as a Claude Code plugin from the Anthropic marketplace. This is the fastest path for Claude Code users.
npx -y @tigerdata/pg-aiguideAdd pg-aiguide to VS Code
Use the VS Code CLI to register the pg-aiguide MCP server via its hosted HTTP endpoint.
code --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'Add pg-aiguide to Gemini CLI
Register the hosted MCP server with Gemini CLI using HTTP transport.
gemini mcp add -s user pg-aiguide "https://mcp.tigerdata.com/docs" -t httpAdd pg-aiguide to Codex CLI
Register the MCP server with the OpenAI Codex CLI.
codex mcp add --url "https://mcp.tigerdata.com/docs" pg-aiguideUse pg-aiguide in your AI coding session
With pg-aiguide connected, ask your AI assistant PostgreSQL questions. The assistant will automatically invoke search_docs or view_skill to retrieve accurate, version-aware documentation and best-practice guidance before generating SQL.
Postgres AI Guide Examples
Client configuration (Claude Desktop / JSON MCP config)
For MCP clients that use a JSON configuration file, connect to pg-aiguide via its hosted HTTP endpoint.
{
"mcpServers": {
"pg-aiguide": {
"type": "http",
"url": "https://mcp.tigerdata.com/docs"
}
}
}Prompts to try
With pg-aiguide connected, your AI assistant will use it automatically when answering PostgreSQL questions. You can also invoke it explicitly.
- "Design a users table with proper constraints and indexes for a SaaS application"
- "What is the best way to implement time-series data storage in PostgreSQL using TimescaleDB?"
- "Show me the correct way to use JSONB indexes in PostgreSQL 16"
- "What are the recommended naming conventions for PostgreSQL tables and columns?"
- "How should I implement row-level security for a multi-tenant schema?"Troubleshooting Postgres AI Guide
The AI assistant does not appear to be using pg-aiguide's tools
Verify the MCP server is connected by checking your client's MCP server list. For Claude Code, run 'claude mcp list' to confirm pg-aiguide appears. You can also explicitly prompt: 'Use the pg-aiguide search_docs tool to find documentation on...'.
Connection to https://mcp.tigerdata.com/docs fails or times out
Check your internet connection and corporate firewall rules. The endpoint is a public HTTPS service with no authentication required. If behind a proxy, ensure your MCP client's HTTP client respects your system proxy settings.
search_docs returns results for the wrong PostgreSQL version
Include the target version explicitly in your query, e.g., 'PostgreSQL 16 COPY statement syntax'. The search_docs tool is version-aware and will prioritize documentation matching the version you specify.
Frequently Asked Questions about Postgres AI Guide
What is Postgres AI Guide?
Postgres AI Guide is a Model Context Protocol (MCP) server that mcp server and claude plugin for postgres skills and documentation. helps ai coding tools generate better postgresql code. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Postgres AI Guide?
Install via npm with the command: npx -y @tigerdata/pg-aiguide. Then add the server configuration to your AI client's JSON config file (e.g., claude_desktop_config.json or .cursor/mcp.json).
Which AI clients work with Postgres AI Guide?
Postgres AI Guide works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Postgres AI Guide free to use?
Yes, Postgres AI Guide is open source and available under the Apache-2.0 license. You can use it freely in both personal and commercial projects.
Postgres AI Guide Alternatives — Similar Databases Servers
Looking for alternatives to Postgres AI Guide? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
MySQL
★ 1.7kProvides access to MySQL databases with fine-grained access control, supporting multiple databases simultaneously with configurable access modes (readonly, readwrite, full) and table-level permissions using whitelists, blacklists, wildcards, and rege
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Postgres AI Guide in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Postgres AI Guide?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.