Comprehensive PostgreSQL documentation and best practices through semantic search and curated skills, including ecosystem tools like TimescaleDB and Tiger Cloud
npm install @tigerdata/pg-aiguideAI-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
Use it either as:
- 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.
AI coding tools often generate Postgres code that is:
- outdated
- missing constraints and indexes
- unaware of modern PG features
- inconsistent with real-world best practices
pg-aiguide fixes that by giving AI agents deep, versioned PostgreSQL knowledge and proven patterns.
https://github.com/user-attachments/assets/5a426381-09b5-4635-9050-f55422253a3d
Video Transcript
Prompt given to Claude Code:
> Please describe the schema you would create for an e-commerce website two times, first with the tiger mcp server disabled, then with the tiger mcp server enabled. For each time, write the schema to its own file in the current working directory. Then compare the two files and let me know which approach generated the better schema, using both qualitative and quantitative reasons. For this example, only use standard Postgres.
Result (summarized):
- 4× more constraints
- 55% more indexes (including partial/expression indexes)
- PG17-recommended patterns
- Modern features (GENERATED ALWAYS AS IDENTITY, NULLS NOT DISTINCT)
- Cleaner naming & documentation
Conclusion: _pg-aiguide produces more robust, performant, maintainable schemas._
pg-aiguide is available as a public MCP server:
https://mcp.tigerdata.com/docs
Manual MCP configuration using JSON
``json`
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}
Or it can be used as a Claude Code Plugin:
`bash`
claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide
#### One-click installs
Claude Code
This repo serves as a claude code marketplace plugin. To install, run:
`bash`
claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide
This plugin uses the skills available in the skills directory as well as our
publicly available MCP server endpoint hosted by TigerData for searching PostgreSQL documentation.
Codex
Run the following to add the MCP server to codex:
`bash`
codex mcp add --url "https://mcp.tigerdata.com/docs" pg-aiguide
Cursor
One-click install:
Or add the following to .cursor/mcp.json
`json`
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}
Gemini CLI
Run the following to add the MCP server to Gemini CLI:
`bash`
gemini mcp add -s user pg-aiguide "https://mcp.tigerdata.com/docs" -t http
Visual Studio
Click the button to install:
VS Code
Click the button to install:
Alternatively, run the following to add the MCP server to VS Code:
`bash`
code --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'
VS Code Insiders
Click the button to install:
Alternatively, run the following to add the MCP server to VS Code Insiders:
`bash`
code-insiders --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'
Windsurf
Add the following to ~/.codeium/windsurf/mcp_config.json
`json`
{
"mcpServers": {
"pg-aiguide": {
"serverUrl": "https://mcp.tigerdata.com/docs"
}
}
}
Once installed, pg-aiguide can answer Postgres questions or design schemas.
Simple schema example prompt
> Create a Postgres table schema for storing usernames and unique email addresses.
Complex schema example prompt
> You are a senior software engineer. You are given a task to generate a Postgres schema for an IoT device company.
> The devices collect environmental data on a factory floor. The data includes temperature, humidity, pressure, as
> the main data points as well as other measurements that vary from device to device. Each device has a unique id
> and a human-readable name. We want to record the time the data was collected as well. Analysis for recent data
> includes finding outliers and anomalies based on measurements, as well as analyzing the data of particular devices for ad-hoc analysis. Historical data analysis includes analyzing the history of data for one device or getting statistics for all devices over long periods of time.
- semantic_search_postgres_docs
Performs semantic search over the official PostgreSQL manual, with results scoped to a specific Postgres version.
- semantic_search_tiger_docs
Searches Tiger Data’s documentation corpus, including TimescaleDB and future ecosystem extensions.
- view_skill`
Exposes curated, opinionated PostgreSQL best-practice skills used automatically by AI coding assistants.
These skills provide guidance on:
- Schema design
- Indexing strategies
- Data types
- Data integrity and constraints
- Naming conventions
- Performance tuning
- Modern PostgreSQL features
Supported today:
- TimescaleDB (docs + skills)
Coming soon:
- pgvector
- PostGIS
We welcome contributions for additional extensions and tools.
See DEVELOPMENT.md for:
- running the MCP server locally
- adding new skills
- adding new docs
We welcome:
- new Postgres best-practice skills
- additional documentation corpora
- search quality improvements
- bug reports and feature ideas
Apache 2.0