Pg Aiguide
Rank #1,892io.github.timescale/pg-aiguide
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
Pg Aiguide is a Model Context Protocol (MCP) server published by timescale. It ranks #1,892 of 115,460 servers tracked on MCP Toplist, and its repository has 1,826 GitHub stars. Pg Aiguide is listed across 4 registries — Official MCP, Glama, PulseMCP and mcp.so, with 6 tracked versions. It was first listed on Jul 23, 2025 and most recently updated on Apr 28, 2026.
Ranks ahead of 113,568 of 115,460 servers on MCP Toplist.
Use Pg Aiguide
No credentials or required configuration declared — add it to your MCP client and go.
claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docsclaude mcp add pg-aiguide -e "OPENAI_API_KEY=<your OPENAI_API_KEY>" -e "PGHOST=<your PGHOST>" -e "PGPORT=<your PGPORT>" -e "PGUSER=<your PGUSER>" -e "PGPASSWORD=<your PGPASSWORD>" -e "PGDATABASE=<your PGDATABASE>" -e "DB_SCHEMA=<your DB_SCHEMA>" -- npx -y @tigerdata/pg-aiguideReplace each placeholder with your own value before saving.
claude mcp add pg-aiguide -e "OPENAI_API_KEY=<your OPENAI_API_KEY>" -e "PGHOST=<your PGHOST>" -e "PGPORT=<your PGPORT>" -e "PGUSER=<your PGUSER>" -e "PGPASSWORD=<your PGPASSWORD>" -e "PGDATABASE=<your PGDATABASE>" -e "DB_SCHEMA=<your DB_SCHEMA>" -- docker run -i --rm ghcr.io/timescale/pg-aiguide:0.2.4Replace each placeholder with your own value before saving.
[mcp_servers.pg-aiguide]
url = "https://mcp.tigerdata.com/docs"Add to ~/.codex/config.toml.
[mcp_servers.pg-aiguide]
command = "npx"
args = ["-y", "@tigerdata/pg-aiguide"]
[mcp_servers.pg-aiguide.env]
OPENAI_API_KEY = "<your OPENAI_API_KEY>"
PGHOST = "<your PGHOST>"
PGPORT = "<your PGPORT>"
PGUSER = "<your PGUSER>"
PGPASSWORD = "<your PGPASSWORD>"
PGDATABASE = "<your PGDATABASE>"
DB_SCHEMA = "<your DB_SCHEMA>"Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.
[mcp_servers.pg-aiguide]
command = "docker"
args = ["run", "-i", "--rm", "ghcr.io/timescale/pg-aiguide:0.2.4"]
[mcp_servers.pg-aiguide.env]
OPENAI_API_KEY = "<your OPENAI_API_KEY>"
PGHOST = "<your PGHOST>"
PGPORT = "<your PGPORT>"
PGUSER = "<your PGUSER>"
PGPASSWORD = "<your PGPASSWORD>"
PGDATABASE = "<your PGDATABASE>"
DB_SCHEMA = "<your DB_SCHEMA>"Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.
https://mcp.tigerdata.com/docsSettings → Connectors → “Add custom connector”, then paste this URL.
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide"
],
"env": {
"OPENAI_API_KEY": "<your OPENAI_API_KEY>",
"PGHOST": "<your PGHOST>",
"PGPORT": "<your PGPORT>",
"PGUSER": "<your PGUSER>",
"PGPASSWORD": "<your PGPASSWORD>",
"PGDATABASE": "<your PGDATABASE>",
"DB_SCHEMA": "<your DB_SCHEMA>"
}
}
}
}Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.
{
"mcpServers": {
"pg-aiguide": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/timescale/pg-aiguide:0.2.4"
],
"env": {
"OPENAI_API_KEY": "<your OPENAI_API_KEY>",
"PGHOST": "<your PGHOST>",
"PGPORT": "<your PGPORT>",
"PGUSER": "<your PGUSER>",
"PGPASSWORD": "<your PGPASSWORD>",
"PGDATABASE": "<your PGDATABASE>",
"DB_SCHEMA": "<your DB_SCHEMA>"
}
}
}
}Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project).
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide"
],
"env": {
"OPENAI_API_KEY": "<your OPENAI_API_KEY>",
"PGHOST": "<your PGHOST>",
"PGPORT": "<your PGPORT>",
"PGUSER": "<your PGUSER>",
"PGPASSWORD": "<your PGPASSWORD>",
"PGDATABASE": "<your PGDATABASE>",
"DB_SCHEMA": "<your DB_SCHEMA>"
}
}
}
}Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.
{
"mcpServers": {
"pg-aiguide": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/timescale/pg-aiguide:0.2.4"
],
"env": {
"OPENAI_API_KEY": "<your OPENAI_API_KEY>",
"PGHOST": "<your PGHOST>",
"PGPORT": "<your PGPORT>",
"PGUSER": "<your PGUSER>",
"PGPASSWORD": "<your PGPASSWORD>",
"PGDATABASE": "<your PGDATABASE>",
"DB_SCHEMA": "<your DB_SCHEMA>"
}
}
}
}Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.
{
"servers": {
"pg-aiguide": {
"type": "http",
"url": "https://mcp.tigerdata.com/docs"
}
}
}Save as .vscode/mcp.json in your workspace.
{
"servers": {
"pg-aiguide": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide"
],
"env": {
"OPENAI_API_KEY": "<your OPENAI_API_KEY>",
"PGHOST": "<your PGHOST>",
"PGPORT": "<your PGPORT>",
"PGUSER": "<your PGUSER>",
"PGPASSWORD": "<your PGPASSWORD>",
"PGDATABASE": "<your PGDATABASE>",
"DB_SCHEMA": "<your DB_SCHEMA>"
}
}
}
}Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.
{
"servers": {
"pg-aiguide": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/timescale/pg-aiguide:0.2.4"
],
"env": {
"OPENAI_API_KEY": "<your OPENAI_API_KEY>",
"PGHOST": "<your PGHOST>",
"PGPORT": "<your PGPORT>",
"PGUSER": "<your PGUSER>",
"PGPASSWORD": "<your PGPASSWORD>",
"PGDATABASE": "<your PGDATABASE>",
"DB_SCHEMA": "<your DB_SCHEMA>"
}
}
}
}Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.
{
"mcpServers": {
"pg-aiguide": {
"serverUrl": "https://mcp.tigerdata.com/docs"
}
}
}Add to ~/.codeium/windsurf/mcp_config.json.
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide"
],
"env": {
"OPENAI_API_KEY": "<your OPENAI_API_KEY>",
"PGHOST": "<your PGHOST>",
"PGPORT": "<your PGPORT>",
"PGUSER": "<your PGUSER>",
"PGPASSWORD": "<your PGPASSWORD>",
"PGDATABASE": "<your PGDATABASE>",
"DB_SCHEMA": "<your DB_SCHEMA>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.
{
"mcpServers": {
"pg-aiguide": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/timescale/pg-aiguide:0.2.4"
],
"env": {
"OPENAI_API_KEY": "<your OPENAI_API_KEY>",
"PGHOST": "<your PGHOST>",
"PGPORT": "<your PGPORT>",
"PGUSER": "<your PGUSER>",
"PGPASSWORD": "<your PGPASSWORD>",
"PGDATABASE": "<your PGDATABASE>",
"DB_SCHEMA": "<your DB_SCHEMA>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide"
],
"env": {
"OPENAI_API_KEY": "<your OPENAI_API_KEY>",
"PGHOST": "<your PGHOST>",
"PGPORT": "<your PGPORT>",
"PGUSER": "<your PGUSER>",
"PGPASSWORD": "<your PGPASSWORD>",
"PGDATABASE": "<your PGDATABASE>",
"DB_SCHEMA": "<your DB_SCHEMA>"
}
}
}
}Replace each placeholder with your own value before saving.
{
"mcpServers": {
"pg-aiguide": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/timescale/pg-aiguide:0.2.4"
],
"env": {
"OPENAI_API_KEY": "<your OPENAI_API_KEY>",
"PGHOST": "<your PGHOST>",
"PGPORT": "<your PGPORT>",
"PGUSER": "<your PGUSER>",
"PGPASSWORD": "<your PGPASSWORD>",
"PGDATABASE": "<your PGDATABASE>",
"DB_SCHEMA": "<your DB_SCHEMA>"
}
}
}
}Replace each placeholder with your own value before saving.
Show your rank
Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.
[](https://mcptoplist.com/server/io.github.timescale%2Fpg-aiguide)<a href="https://mcptoplist.com/server/io.github.timescale%2Fpg-aiguide"><img src="https://mcptoplist.com/badge/io.github.timescale%2Fpg-aiguide.svg" alt="MCP Toplist: Top 5% of 115,460" /></a>Variants: append ?metric=score or ?metric=stars to the image URL.
Listed on 2 registries (2 delisted)
timescale
Other servers by timescale
- RSigma#636 · 6 vers
- Tiger MCP#932 · 10 vers
- Tiger Salesforce MCP Server#12,846
- Tiger Skills#19,336 · 2 vers
- Tiger Linear MCP Server#19,639
- Tiger GitHub MCP Server#20,281
- Tiger Memory MCP Server#20,454
Available versions (6)
| Version | Published |
|---|---|
| 0.5.0 | Apr 28, 2026 |
| 0.4.0 | Mar 18, 2026 |
| 0.3.1 | Feb 23, 2026 |
| 0.2.4 | Dec 10, 2025 |
| 0.2.3 | Dec 9, 2025 |
| 0.1.0 | Nov 25, 2024 |
Frequently asked questions
- Who maintains Pg Aiguide?
- Pg Aiguide is maintained by timescale, which publishes 8 MCP servers (24 total versions) tracked on MCP Toplist.
- Is Pg Aiguide listed on the Official MCP Registry?
- Yes — Pg Aiguide is listed on the Official MCP Registry, alongside Glama, PulseMCP and mcp.so.
- How many versions does Pg Aiguide have?
- MCP Toplist tracks 6 versions of Pg Aiguide, most recently published on Apr 28, 2026.
- Where can I find the source code for Pg Aiguide?
- The source code for Pg Aiguide is hosted at github.com/timescale/pg-aiguide.