skills.rest
MassimilianoPili
MassimilianoPiliCOMMUNITY
Explore all skills by this author →
GitHub

dba-postgres

Manage PostgreSQL 16+ schemas, Flyway migrations, indexing, and query optimization.

Updated Mar 7, 2026
Search Tags:#schema design#database#postgresql#migrations#sql#performance tuning#dba
One-click install
npx skills add https://github.com/MassimilianoPili/agent-framework --skill dba-postgres
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dba-postgres
Source: https://github.com/MassimilianoPili/agent-framework/tree/main/.claude/agents/dba-postgres
Command: npx skills add https://github.com/MassimilianoPili/agent-framework --skill dba-postgres

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines complex PostgreSQL database tasks, ensuring efficient schema design, robust migrations, and optimized query performance for PostgreSQL 16 and later.

Core Features & Use Cases

  • Schema Design & Migrations: Create and manage database schemas and Flyway migrations.
  • Performance Tuning: Optimize queries using EXPLAIN ANALYZE and implement effective indexing strategies.
  • Advanced Features: Leverage partitioning, extensions (like pgvector, PostGIS), and Row Level Security (RLS).
  • Use Case: Design a new users table with UUID primary keys, TIMESTAMPTZ for registration dates, and a GIN index on a JSONB column for user preferences, generating the corresponding Flyway migration script.

Quick Start

Use the dba-postgres skill to create a Flyway migration script for a new products table with columns for id, name, description, and price.

Frequently Asked Questions about dba-postgres

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a Flyway migration script for a new PostgreSQL table with UUID and JSONB columns?▼

To optimize a slow PostgreSQL query, use EXPLAIN ANALYZE to analyze the execution plan and identify bottlenecks. The skill supports query performance analysis and implements effective indexing strategies to improve database retrieval speed.

What is the best way to implement Row Level Security in PostgreSQL 16+?▼

Yes, you can integrate pgvector with PostgreSQL by leveraging database extensions. The skill supports extension integration for advanced features like pgvector, enabling vector similarity searches alongside standard relational data operations.

Does this skill support partitioning and PostGIS extension integration for PostgreSQL?▼

Yes, this skill supports partitioning and PostGIS extension integration. It manages advanced PostgreSQL features including table partitioning for large datasets and spatial data handling through extension configuration.

How do I optimize slow PostgreSQL queries using EXPLAIN ANALYZE and indexing strategies?▼

To optimize slow PostgreSQL queries, use EXPLAIN ANALYZE to review execution plans and apply effective indexing strategies. The skill analyzes query performance and implements index improvements to streamline data retrieval.

What is the recommended schema design for a PostgreSQL table using UUID primary keys and JSONB indexes?▼

The recommended schema design uses UUID primary keys, TIMESTAMPTZ for registration dates, and GIN indexes on JSONB columns for user preferences. This skill manages PostgreSQL schema design and generates the Flyway migration scripts.

Related Skills

Explore More Software Engineering Skills→
jabrenajabrena
423

513-frameworks-micronaut-db-migrations-flyway

Manage Flyway database migrations in Micronaut applications.

Community
Advanced
nksethnkseth

database-optimizer

Analyze PostgreSQL and MySQL query performance using EXPLAIN ANALYZE.

Community
Advanced
bobmatnycbobmatnyc
68

neon-serverless-postgres

Set up Neon serverless Postgres with Drizzle ORM and Prisma.

Community
Intermediate
rafaelcallejarafaelcalleja
2

databases

Manage PostgreSQL and MongoDB schema design, queries, and administration.

Community
Advanced