SkillFoxx

Type a name, a task or a service

pg-aiguide

An MCP server and skills from TigerData that help agents write PostgreSQL schemas and queries from current docs and practices

MCP serverEditors’ pickMedium risk

timescale/pg-aiguideAuthor: TigerData

Install

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

Without --skill the installer lets you pick skills.

This is third-party code. Review the repository files before installing.

What it does

The project targets common agent weaknesses with PostgreSQL: outdated syntax, missing constraints and indexes, and unawareness of newer features. The public MCP server exposes search_docs with semantic and BM25 search over the version-aware PostgreSQL manual plus TimescaleDB and PostGIS docs. Skills cover table design, PostGIS spatial tables, TimescaleDB hypertables and migrating to them, pgvector semantic search, hybrid text search and database migrations. It installs as skills, as a remote MCP server or as a Claude Code plugin.

Who it is for. For backend developers and data engineers designing PostgreSQL databases with an agent.

Good fit when

  • The agent designs a PostgreSQL schema and needs proper constraints and indexes
  • You are setting up time series on TimescaleDB or geodata on PostGIS
  • You want the agent's answer checked against the manual for your PostgreSQL version

Not a fit when

  • The database is MySQL, SQLite or another DBMS
  • You need the agent to access your live database: the server only searches documentation

Example request

Design a PostgreSQL schema for IoT sensor telemetry with fast recent-data analysis and long history

Limitations

The remote MCP server is hosted by TigerData, so queries go to their infrastructure. Some skills lean toward Timescale ecosystem choices. pgvector documentation support is listed as coming later.

How to disable. Remove the pg-aiguide server from the agent's MCP config, the plugin via claude plugin uninstall, or the skill folders from the agent directory.

MCP

Transport
http
Authentication
not required

Security check

  • Agent queries go to TigerData's remote server
  • Skills generate DDL and migrations that need review before applying

README in short

The README compares e-commerce schemas generated with and without the server: more constraints and indexes and modern PostgreSQL constructs. It covers installing skills via npx skills, connecting the remote MCP in Claude Code, Codex, Cursor, Gemini CLI, OpenCode, VS Code and Windsurf, and installing the Claude Code plugin. It describes the search_docs and view_skill tools and supported doc corpora. Apache 2.0 licensed.

FAQ

Is an API key needed?

No, the public server connects by URL without authentication.

How do skills differ from the MCP server?

Skills give ready design rules, while the MCP server searches full documentation. The authors suggest using both.

Editors’ pick

166 skills for scientific work: bioinformatics, cheminformatics, clinical data, geospatial analysis and 100+ databases

SkillMedium risk44.9K
Editors’ pick

Google's open-source MCP server for databases: ready tools for Postgres, MySQL, BigQuery, Spanner and more, plus custom tools in tools.yaml

MCP serverHigh risk16.4K
Editors’ pick

Official Hugging Face skills: Hub operations via the hf CLI, datasets, model training, Spaces, evals and deployment

SkillHigh risk11K
Editors’ pick

A token-lean MCP server for PostgreSQL, MySQL, MariaDB, SQL Server and SQLite with a read-only mode

MCP serverHigh risk3.5K