Optimize PostgreSQL queries using EXPLAIN ANALYZE and indexing strategies.
npx skills add https://github.com/avvale/aurora-back --skill postgresql-avvale
Please help me install this Agent Skill. Skill: postgresql Source: https://github.com/avvale/aurora-back/tree/main/.claude/skills/postgresql Command: npx skills add https://github.com/avvale/aurora-back --skill postgresql-avvale
This Skill provides comprehensive guidance and tools for efficiently managing, querying, and optimizing PostgreSQL databases, ensuring robust and high-performing data solutions.
EXPLAIN ANALYZE and optimize database configurations.SELECT query by analyzing its EXPLAIN ANALYZE output, identifying missing indexes, and rewriting the query for better performance.Use the postgresql skill to generate a CREATE TABLE statement for a users table with id, name, email, and created_at columns.
High-intent search queries and answers about installing and using this skill.
PostgreSQL query optimization involves running EXPLAIN ANALYZE to inspect execution plans, identifying sequential scans or missing indexes, and rewriting complex SQL with CTEs or window functions to reduce bottlenecks and improve performance.
Schema design in PostgreSQL requires selecting appropriate data types for storage efficiency and structuring tables to support scalability. Effective indexing strategies must be implemented alongside the schema to ensure fast data retrieval as the dataset grows.
Advanced SQL querying in PostgreSQL supports writing complex Common Table Expressions (CTEs), window functions for analytical processing, and full-text search operations to handle sophisticated data retrieval requirements efficiently.
PostgreSQL supports various extensions to enhance database management and performance tuning. These extensions can be leveraged alongside indexing strategies and query rewriting to troubleshoot and resolve complex performance bottlenecks.
PostgreSQL performance tuning is needed when slow queries degrade application responsiveness. Analyzing execution plans and applying effective indexing strategies ensures the database handles high-volume data retrieval without bottlenecks.
Full-text search in PostgreSQL is used when standard SQL queries cannot efficiently handle complex text matching. It leverages specialized indexing strategies to provide fast, relevant search results across large volumes of text data.
ThalfmanApply Postgres performance and schema design best practices.
hieuckOptimize ClickHouse analytical workloads with schema and query patterns.
fgarofalo56Build full-stack applications with Supabase authentication, PostgreSQL, and Edge Functions.
brenordvModel NoSQL database systems using query-driven structures and horizontal scalability.