MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Setup
Choose your client, copy the config, then fill in any required environment variables.
Local
claude mcp add pg-aiguide --env OPENAI_API_KEY='<OPENAI_API_KEY>' --env PGHOST='<PGHOST>' --env PGPORT='<PGPORT>' --env PGUSER='<PGUSER>' --env PGPASSWORD='<PGPASSWORD>' --env PGDATABASE='<PGDATABASE>' --env DB_SCHEMA='<DB_SCHEMA>' -- npx -y @tigerdata/pg-aiguide~/.codex/config.toml
[mcp_servers.pg-aiguide]
command = "npx"
args = ["-y", "@tigerdata/pg-aiguide"]
env = { OPENAI_API_KEY = "<OPENAI_API_KEY>", PGHOST = "<PGHOST>", PGPORT = "<PGPORT>", PGUSER = "<PGUSER>", PGPASSWORD = "<PGPASSWORD>", PGDATABASE = "<PGDATABASE>", DB_SCHEMA = "<DB_SCHEMA>" }
# codex mcp add pg-aiguide --env OPENAI_API_KEY='<OPENAI_API_KEY>' --env PGHOST='<PGHOST>' --env PGPORT='<PGPORT>' --env PGUSER='<PGUSER>' --env PGPASSWORD='<PGPASSWORD>' --env PGDATABASE='<PGDATABASE>' --env DB_SCHEMA='<DB_SCHEMA>' -- npx -y @tigerdata/pg-aiguide~/.cursor/mcp.json
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide"
],
"env": {
"OPENAI_API_KEY": "<OPENAI_API_KEY>",
"PGHOST": "<PGHOST>",
"PGPORT": "<PGPORT>",
"PGUSER": "<PGUSER>",
"PGPASSWORD": "<PGPASSWORD>",
"PGDATABASE": "<PGDATABASE>",
"DB_SCHEMA": "<DB_SCHEMA>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"pg-aiguide": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide"
],
"env": {
"OPENAI_API_KEY": "<OPENAI_API_KEY>",
"PGHOST": "<PGHOST>",
"PGPORT": "<PGPORT>",
"PGUSER": "<PGUSER>",
"PGPASSWORD": "<PGPASSWORD>",
"PGDATABASE": "<PGDATABASE>",
"DB_SCHEMA": "<DB_SCHEMA>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide"
],
"env": {
"OPENAI_API_KEY": "<OPENAI_API_KEY>",
"PGHOST": "<PGHOST>",
"PGPORT": "<PGPORT>",
"PGUSER": "<PGUSER>",
"PGPASSWORD": "<PGPASSWORD>",
"PGDATABASE": "<PGDATABASE>",
"DB_SCHEMA": "<DB_SCHEMA>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide"
],
"env": {
"OPENAI_API_KEY": "<OPENAI_API_KEY>",
"PGHOST": "<PGHOST>",
"PGPORT": "<PGPORT>",
"PGUSER": "<PGUSER>",
"PGPASSWORD": "<PGPASSWORD>",
"PGDATABASE": "<PGDATABASE>",
"DB_SCHEMA": "<DB_SCHEMA>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide"
],
"env": {
"OPENAI_API_KEY": "<OPENAI_API_KEY>",
"PGHOST": "<PGHOST>",
"PGPORT": "<PGPORT>",
"PGUSER": "<PGUSER>",
"PGPASSWORD": "<PGPASSWORD>",
"PGDATABASE": "<PGDATABASE>",
"DB_SCHEMA": "<DB_SCHEMA>"
}
}
}
}Remote
claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docs~/.codex/config.toml
[mcp_servers.pg-aiguide]
url = "https://mcp.tigerdata.com/docs"
# codex mcp add pg-aiguide --url https://mcp.tigerdata.com/docs~/.cursor/mcp.json
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}.vscode/mcp.json
{
"servers": {
"pg-aiguide": {
"type": "http",
"url": "https://mcp.tigerdata.com/docs"
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"pg-aiguide": {
"httpUrl": "https://mcp.tigerdata.com/docs"
}
}
}claude_desktop_config.json · Customize › Connectors › Add custom connector
{
"mcpServers": {
"pg-aiguide": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://mcp.tigerdata.com/docs"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}Environment variables
OPENAI_API_KEYPGHOSTPGPORTPGUSERPGPASSWORDPGDATABASEDB_SCHEMA
Replace the placeholders with your own credentials and keep them out of version control.