@timescale/postgres
|
No skills found in this collection.
SKILL.md
| name | postgres |
| description | | |
| license | Apache-2.0 |
| metadata | Design or modify PostgreSQL tables, schemas, or data models, Choose data types, constraints, indexes, or partitioning strategies, Work with pgvector embeddings, semantic search, or RAG, Set up full-text search, hybrid search, or BM25 ranking, Use PostGIS for spatial/geographic data, Set up TimescaleDB hypertables for time-series data, Migrate tables to hypertables or evaluate migration candidates, Plan or execute safe schema migrations with zero downtime, Create, fork, or manage databases with Ghost |
PostgreSQL Expert Skills
This skill provides comprehensive PostgreSQL expertise through specialized references. Load the appropriate reference based on the task.
Available References
Table Design
- design-postgres-tables — Data types, constraints, indexes, JSONB patterns, partitioning, and PostgreSQL best practices. Use for any general table/schema design task.
- design-postgis-tables — PostGIS spatial table design: geometry vs geography types, SRIDs, spatial indexing, and location-based query patterns. Use when the task involves geographic or spatial data.
Search
- pgvector-semantic-search — Vector similarity search with pgvector: HNSW/IVFFlat indexes, halfvec storage, quantization, filtered search, and tuning. Use for embeddings, RAG, or semantic search.
- postgres-hybrid-text-search — Hybrid search combining BM25 keyword search with pgvector semantic search using RRF. Use when combining keyword and meaning-based search.
TimescaleDB
- setup-timescaledb-hypertables — Hypertable creation, compression, retention policies, continuous aggregates, and indexes. Use when setting up TimescaleDB from scratch.
- find-hypertable-candidates — SQL queries to analyze existing tables and score them for hypertable conversion. Use when evaluating which tables to migrate.
- migrate-postgres-tables-to-hypertables — Step-by-step migration: partition column selection, in-place vs blue-green, validation. Use when executing a migration.
Migrations
- postgres-database-migration — DDL lock reference, safe migration patterns, timeout strategies, rollback planning, and fork-based testing. Use when planning or executing schema changes on production databases.
Database Management
- ghost-database — Ghost is a managed PostgreSQL service designed for AI agents. Create, fork, pause, resume, and query databases via CLI or MCP. Use when the user needs a database for agent workflows or wants to fork for safe experimentation.
How to Use
- Identify which reference matches the user's task from the descriptions above.
- Load the reference file to get detailed instructions and SQL patterns.
- For tasks spanning multiple areas (e.g., "design a table with vector search"), load multiple references as needed.
Loading...
Select a file to preview
Analyzing security...
Checking scan reports and verification data.
Bill of Materials
Everything this skill can do — files, network, commands, and more.
No demos yet. To add one, ask your AI agent: "Submit a demo for @timescale/postgres" — or upload via the API.
To add a demo, ask your AI agent: "Submit a demo for @timescale/postgres"
No eval data yet. Eval results are published via the SkillSafe API.