Community Plugin

pg

Name: pg
Rating: 5.0 (1090 reviews)
Author: timescale

Comprehensive PostgreSQL documentation and best practices through semantic search and curated skills, including ecosystem tools like TimescaleDB and Tiger Cloud

0.1.0

Updated 22 days ago

Capabilities

Commands

Agents

Skills

Hooks

MCP Servers

Install

Add the repository(one-time)

/plugin marketplace add timescale/pg-aiguide

Install the plugin

/plugin install pg@aiguide

Security Notice

Connects to external services via MCP

Component Details

design-postgres-tables

inherits

Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features

find-hypertable-candidates

inherits

Analyze an existing PostgreSQL database to identify tables that would benefit from conversion to TimescaleDB hypertables

migrate-postgres-tables-to-hypertables

inherits

Comprehensive guide for migrating PostgreSQL tables to TimescaleDB hypertables with optimal configuration and performance validation

setup-timescaledb-hypertables

inherits

Step-by-step instructions for designing table schemas and setting up TimescaleDB with hypertables, indexes, compression, retention policies, and continuous aggregates. Instructions for selecting: partition columns, segment_by columns, order_by columns, chunk time interval, real-time aggregation.