pg-aiguide
Gives AI coding assistants PostgreSQL guidance for table design, converting tables to TimescaleDB hypertables, PostGIS spatial schemas, and pgvector semantic search. Useful for developers building databases with an AI coding tool.

Gives AI coding assistants PostgreSQL guidance for table design, converting tables to TimescaleDB hypertables, PostGIS spatial schemas, and pgvector semantic search. Useful for developers building databases with an AI coding tool.
Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and…
Use this skill for general PostgreSQL table design. **Trigger when user asks to:** - Design PostgreSQL tables, schemas, or data…
Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB…
Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and…
Use this skill for setting up vector similarity search with pgvector for AI/ML embeddings, RAG applications, or semantic search.…
Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS,…
Use this skill for planning, testing, and safely executing PostgreSQL schema migrations — especially when working with production…
Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion…
Explore an existing PostgreSQL database before answering questions about its data or writing SQL. Use this skill whenever a user…
Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for…
Use this skill when writing analytical SQL over time-series data with the TimescaleDB Toolkit (timescaledb_toolkit extension)…
Is this you? Claim your profilePut a plugin at the top of Plugins, from $9