<Devsly/>
NotebookLM Watermark Remover
Remove the NotebookLM watermark from PDF slide exports — free, unlimited, and 100% in your browser.
View
NotebookLM Video Watermark Remover
Remove the NotebookLM watermark from every frame of your MP4 and auto-trim the end card — free and unlimited.
View
Gemini Watermark Remover
Remove the Gemini (Veo) sparkle watermark from every frame of your AI-generated MP4 — free and unlimited.
View
MCP https://devsly.io/mcp MCP Tools Best Skills API Docs
Devsly

Keyboard Shortcuts

Navigation

Quick Search
⌘ / Ctrl + K
Toggle Dark Mode
⌘ / Ctrl + D
Close Dialogs
Esc

Tool Actions

Execute / Process
⌘ / Ctrl + Enter
Clear Input
⌘ / Ctrl + Shift + C
Copy Output
⌘ / Ctrl + Shift + X

Editor

Select All
⌘ / Ctrl + A
Undo
⌘ / Ctrl + Z
Redo
⌘ / Ctrl + Shift + Z

Updated 2d ago

by timescale

pg-aiguide

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

  • Active — Updated in the last 14 days
Works with
  • Claude
View on GitHub (opens in a new tab)

1.9k GitHub stars (1,882)

+27 in 30 days

Stars gained per day · daily snapshots since Sep 26
Stars gained per day, Sep 26 to Nov 5: +33 in total; the busiest day was Nov 3 with +4 stars.Sep 27: 0 starsSep 28: +1 starsSep 29: +2 starsSep 30: −1 starsOct 1: 0 starsOct 2: +2 starsOct 3: +1 starsOct 4: 0 starsOct 5: 0 starsOct 6: +1 starsOct 7: +2 starsOct 8: +2 starsOct 9: +3 starsOct 10: 0 starsOct 11: +2 starsOct 12: 0 starsOct 13: +1 starsOct 14: +2 starsOct 15: +2 starsOct 16: 0 starsOct 17: +1 starsOct 18: +1 starsOct 19: 0 starsOct 20: +1 starsOct 21: 0 starsOct 22: +1 starsOct 23: 0 starsOct 24: −1 starsOct 25: 0 starsOct 26: +1 starsOct 27: +2 starsOct 28: +2 starsOct 29: +2 starsOct 30: 0 starsOct 31: 0 starsNov 1: −2 starsNov 2: 0 starsNov 3: +4 starsNov 4: 0 starsNov 5: +1 stars
Stars gained between daily snapshots
PeriodNew stars
Sep 270
Sep 28+1
Sep 29+2
Sep 30−1
Oct 10
Oct 2+2
Oct 3+1
Oct 40
Oct 50
Oct 6+1
Oct 7+2
Oct 8+2
Oct 9+3
Oct 100
Oct 11+2
Oct 120
Oct 13+1
Oct 14+2
Oct 15+2
Oct 160
Oct 17+1
Oct 18+1
Oct 190
Oct 20+1
Oct 210
Oct 22+1
Oct 230
Oct 24−1
Oct 250
Oct 26+1
Oct 27+2
Oct 28+2
Oct 29+2
Oct 300
Oct 310
Nov 1−2
Nov 20
Nov 3+4
Nov 40
Nov 5+1
  • 11 skills (11 skills found in its SKILL.md files)
  • 120 forks (120 forks)
  • 2d ago last update (Last updated 2d ago)

Install

Skills CLI

npx skills add timescale/pg-aiguide

Asks which skills and agents to install. Just one: npx skills add timescale/pg-aiguide --skill design-postgis-tables — add -g for every project.

Claude Code

git clone https://github.com/timescale/pg-aiguidecp -r "pg-aiguide/skills/design-postgis-tables" ~/.claude/skills/

Copies the design-postgis-tables skill into ~/.claude/skills/ for every project (use .claude/skills/ for one project). Repeat for the other skills listed below.

Plugin

/plugin marketplace add timescale/pg-aiguide

Run inside Claude Code if the repository ships a plugin marketplace, then pick plugins from /plugin.

Skills can run code on your machine — read the SKILL.md first.

What it does

In the author's own words, from each skill's SKILL.md.

  • design-postgis-tables

    Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications

    skills/design-postgis-tables/SKILL.md on GitHub (opens in a new tab)

  • design-postgres-tables

    Use this skill for general PostgreSQL table design. **Trigger when user asks to:** - Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones. - Choose data types, constraints, or indexes for PostgreSQL - Create user tables, order tables, reference tables, or JSONB schemas - Understand PostgreSQL best practices for normalization, constraints, or…

    skills/design-postgres-tables/SKILL.md on GitHub (opens in a new tab)

  • find-hypertable-candidates

    Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. **Trigger when user asks to:** - Analyze database tables for hypertable conversion potential - Identify time-series or event tables in an existing schema - Evaluate if a table would benefit from Timescale/TimescaleDB - Audit PostgreSQL tables for migration…

    skills/find-hypertable-candidates/SKILL.md on GitHub (opens in a new tab)

  • migrate-postgres-tables-to-hypertables

    Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation. **Trigger when user asks to:** - Migrate or convert PostgreSQL tables to hypertables - Execute hypertable migration with minimal downtime - Plan blue-green migration for large tables - Validate hypertable migration success - Configure compression after migration *…

    skills/migrate-postgres-tables-to-hypertables/SKILL.md on GitHub (opens in a new tab)

  • pgvector-semantic-search

    Use this skill for setting up vector similarity search with pgvector for AI/ML embeddings, RAG applications, or semantic search. **Trigger when user asks to:** - Store or search vector embeddings in PostgreSQL - Set up semantic search, similarity search, or nearest neighbor search - Create HNSW or IVFFlat indexes for vectors - Implement RAG (Retrieval Augmented Generation) with PostgreSQL - Optim…

    skills/pgvector-semantic-search/SKILL.md on GitHub (opens in a new tab)

  • postgres-database-migration

    Use this skill for planning, testing, and safely executing PostgreSQL schema migrations — especially when working with production data or shared databases. **Trigger when user asks to:** - Test a schema migration before applying it to production - Add, remove, or rename columns safely on a live table - Change a column's data type without downtime - Add or drop indexes, constraints, or foreign key…

    skills/postgres-database-migration/SKILL.md on GitHub (opens in a new tab)

  • postgres-hybrid-text-search

    Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF). **Trigger when user asks to:** - Combine keyword and semantic search - Implement hybrid search or multi-modal retrieval - Use BM25/pg_textsearch with pgvector together - Implement RRF (Reciprocal Rank Fusion) for search - Build search that handles both exact term…

    skills/postgres-hybrid-text-search/SKILL.md on GitHub (opens in a new tab)

  • postgres

    Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. **Trigger when user asks to:** - Explore an existing PostgreSQL database to understand its objects and relationships - Design or modify PostgreSQL tables, schemas, or data models - Choose data types, constraints, indexes, or partit…

    skills/postgres/SKILL.md on GitHub (opens in a new tab)

  • schema-exploration

    Explore an existing PostgreSQL database before answering questions about its data or writing SQL. Use this skill whenever a user asks for a query or a data-backed answer against an unfamiliar schema (counts, missing or failed records, recent changes), asks where a business concept lives, or asks how tables, joins, views, routines, triggers, RLS, or extensions work. Find the relevant objects with…

    skills/schema-exploration/SKILL.md on GitHub (opens in a new tab)

  • setup-timescaledb-hypertables

    Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics, events, or log data. Use this to improve the performance of any insert-heavy table. **Trigger when user asks to:** - Create or design SQL schemas/tables AND Timescale/TimescaleDB/TigerData/Tiger Cloud is available - Set up hypertables, compressio…

    skills/setup-timescaledb-hypertables/SKILL.md on GitHub (opens in a new tab)

  • timescaledb-hyperfunctions

    Use this skill when writing analytical SQL over time-series data with the TimescaleDB Toolkit (timescaledb_toolkit extension) hyperfunctions: approximate percentiles, statistical summaries, time-weighted averages, counter/gauge rates, uptime/heartbeat tracking, state durations, OHLC candlesticks, approximate distinct counts, top-N, and downsampling. **Trigger when user asks to:** - Compute percen…

    skills/timescaledb-hyperfunctions/SKILL.md on GitHub (opens in a new tab)

Review before you install

A skill is a set of instructions and scripts your agent will follow, and it can run code on your machine. Read the SKILL.md and any scripts first — this listing is not a security review.