ia-postgresql
CommunityDesign safe Postgres schemas with confidence.
Software Engineering#query optimization#indexing#schema design#postgresql#row level security#safe migrations
Authoriliaal
Version1.0.0
Installs0
System Documentation
What problem does it solve?
It helps you design and optimize PostgreSQL schemas and queries while avoiding common production risks like slow plans, missing indexes, unsafe migrations, and insecure row-level access.
Core Features & Use Cases
- Schema design defaults: Apply strong data-type, constraint, and timestamp rules (including JSONB and UUID guidance) tailored to PostgreSQL.
- Migration safety: Follow expand-contract patterns, concurrency-safe index creation, and batch-safe backfills to reduce downtime and data corruption risk.
- Performance and correctness: Use EXPLAIN ANALYZE-driven optimization, robust indexing strategies (B-tree/GiST/GIN/BRIN), and RLS performance practices.
Quick Start
Ask the agent to "add row level security and optimize the query plan for the tenant orders table using EXPLAIN ANALYZE and the correct indexes."
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: ia-postgresql Download link: https://github.com/iliaal/whetstone/archive/main.zip#ia-postgresql Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.