Provide patterns for PostgreSQL querying, indexing, and schema migrations.
npx skills add https://github.com/bennie-ng/AgCel --skill postgresql-bennie-ng
Please help me install this Agent Skill. Skill: PostgreSQL Source: https://github.com/bennie-ng/AgCel/tree/main/skills/postgresql Command: npx skills add https://github.com/bennie-ng/AgCel --skill postgresql-bennie-ng
This Skill helps users manage and optimize PostgreSQL databases by providing patterns for common operations, indexing strategies, and migration techniques.
Use the PostgreSQL skill to create an index on the 'email' column of the 'users' table.
High-intent search queries and answers about installing and using this skill.
PostgreSQL indexing strategies involve creating indexes on specific table columns to accelerate data retrieval. This technique improves query performance by allowing the database engine to locate data faster without scanning entire tables.
The best way to write efficient SQL queries is to follow PostgreSQL-specific best practices and avoid common pitfalls. Efficient querying requires understanding SQL syntax and applying performance optimization patterns during data retrieval and manipulation.
Safely implement database schema migrations in PostgreSQL by using specific SQL commands to apply changes. This migration technique ensures schema modifications are executed properly without disrupting database operations or losing existing data.
Common PostgreSQL performance pitfalls include inefficient query structures and improper indexing. Avoiding these issues requires understanding database optimization patterns and applying best practices to ensure queries and schema migrations perform effectively.
Yes, effective implementation of PostgreSQL optimization patterns requires an existing understanding of SQL syntax. You need knowledge of PostgreSQL-specific features to properly apply indexing strategies and execute schema migrations.
nubivProvide PostgreSQL optimization best practices for queries, schemas, indexes, and security.
PP-NamiasCreate and optimize GROQ queries for Sanity CMS data retrieval.
jeremylongshoreGenerate ORM models and database schemas across multiple frameworks.
AutumnsGroveWrite optimized SQL queries and analyze EXPLAIN plans across major databases.
