pg-aiguide

MCP server by timescale · ★ 1.9k · updated 6 days ago

DatabasesMaintainedRemote availableOne-click install

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

Install View on GitHub

Install pg-aiguide

Choose your AI client and copy the config.

Add to claude_desktop_config.json — macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Then restart Claude.

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "skills",
        "add",
        "timescale/pg-aiguide",
        "--skill",
        "postgres"
      ]
    }
  }
}

Add to Cursor

Or add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "skills",
        "add",
        "timescale/pg-aiguide",
        "--skill",
        "postgres"
      ]
    }
  }
}

Install in VS Code

Or add to .vscode/mcp.json in your workspace.

{
  "servers": {
    "pg-aiguide": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "skills",
        "add",
        "timescale/pg-aiguide",
        "--skill",
        "postgres"
      ]
    }
  }
}

Run in your terminal:

claude mcp add pg-aiguide -- npx skills add timescale/pg-aiguide --skill postgres

Run the server directly:

npx skills add timescale/pg-aiguide --skill postgres

Before you install: Install command taken from the project README. Check the README for any required environment variables.

Related Databases servers

dbx

by t8y2 · Rust

25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具，支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库，提供桌面端、Docker、CLI、内置 AI 助手和 MCP。

DatabasesMaintained26.4k

mcp-toolbox

by googleapis · Go

MCP Toolbox for Databases is an open source MCP server for databases.

DatabasesMaintained16.7k

tabularis

by TabularisDB · TypeScript

Open-source desktop SQL workspace with 3 built-in database drivers and 16 shipped plugins, including SQL Server, DuckDB, ClickHouse and Redis. Built-in MCP server for Claude, Cursor and Devin, SQL notebooks and visual EXPLAIN.

DatabasesMaintained5.2k

prest

by prest · Go

Instant REST and MCP APIs for PostgreSQL and MySQL 8, on existing or new databases. CRUD, custom SQL routes, auth and ACL without writing a backend. Low-code, ⚡ realtime, high-performance. Native MySQL support since v2.5.

DatabasesMaintained4.6k

dbhub

by bytebase · TypeScript

Token conscious database MCP server for Postgres, MySQL, SQL Server, Oracle, MariaDB, SQLite.

DatabasesMaintained3.6k

Postgres MCP Pro

by crystaldba · Python

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

DatabasesMaintainedRemote3.4k