SQL-Datenbanken
PostgreSQL Expert Skills
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:**
- 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
**Keywords:** PostgreSQL, Postgres, SQL, schema, table design, indexes, constraints, pgvector, PostGIS, TimescaleDB, hypertable, semantic search, hybrid search, BM25, time-series