Optimize PostgreSQL schemas, queries, and migrations with EXPLAIN ANALYZE validation.
npx skills add https://github.com/iliaal/whetstone --skill ia-postgresql
Please help me install this Agent Skill. Skill: ia-postgresql Source: https://github.com/iliaal/whetstone/tree/main/plugins/whetstone/skills/ia-postgresql Command: npx skills add https://github.com/iliaal/whetstone --skill ia-postgresql
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.
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."
High-intent search queries and answers about installing and using this skill.
Safe PostgreSQL schema migrations require expand-contract patterns, concurrency-safe index creation, and batch-safe backfills to reduce downtime and data corruption risk during production deployments.
PostgreSQL query optimization requires running EXPLAIN (ANALYZE, BUFFERS) to inspect execution plans, then selecting appropriate indexing strategies like B-tree, GIN, GiST, or BRIN to improve performance.
PostgreSQL row level security (RLS) restricts data access by evaluating policies per row, requiring careful indexing and performance validation through EXPLAIN ANALYZE to ensure secure tenant isolation without degrading query speed.
PostgreSQL JSONB columns store semi-structured data efficiently, and GIN indexes accelerate JSONB key lookups, making them ideal when schema flexibility is needed without sacrificing query performance.
PostgreSQL CTE and window functions handle complex analytical logic, but require EXPLAIN ANALYZE validation to ensure the planner executes efficiently without materializing unnecessary intermediate result sets.
PostgreSQL partitioning improves maintenance and query targeting for large tables, but requires careful constraint design and partition key selection to avoid performance degradation from cross-partition scans.
quanngynxGuide PostgreSQL schema, indexing, and migration changes with EXPLAIN verification.
JeffallanDiagnose slow queries and optimize indexes for PostgreSQL and MySQL.
yuhle-qugAnalyze and optimize database performance across PostgreSQL, MySQL, MongoDB, and SQLite.
BagelHoleManage MySQL-compatible databases on PlanetScale with branching workflows.
