skills.rest
marcoamu
marcoamuCOMMUNITY
Explore all skills by this author →
GitHub

database-operations

Optimize PostgreSQL schemas, migrations, and query performance with EXPLAIN ANALYZE.

1|Updated Mar 14, 2026
Search Tags:#indexing#database#postgresql#migrations#sql#query-optimization#ef-core
One-click install
npx skills add https://github.com/marcoamu/openclaw-workspace --skill database-operations-marcoamu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-operations
Source: https://github.com/marcoamu/openclaw-workspace/tree/main/skills/database-operations
Command: npx skills add https://github.com/marcoamu/openclaw-workspace --skill database-operations-marcoamu

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Streamlines the design of robust PostgreSQL schemas, guides safe migrations, and enhances query performance across production databases.

Core Features & Use Cases

  • Schema design: best practices for table structures, types, constraints, and data integrity.
  • Migration strategy: zero-downtime migrations with safe rollout plans and rollback procedures.
  • Performance optimization: instrumentation with EXPLAIN ANALYZE, indexing strategies, and caching approaches.
  • EF Core integration: migration workflows and design considerations when using EF Core with PostgreSQL.

Quick Start

Execute a guided PostgreSQL optimization by running a baseline analysis and implementing the recommended improvements in your environment.

Frequently Asked Questions about database-operations

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

FAQPage Schema
How do I optimize slow PostgreSQL query performance?▼

Optimize PostgreSQL query performance by running EXPLAIN ANALYZE to identify bottlenecks, then applying targeted indexing strategies and caching approaches to improve database efficiency.

What is a safe zero-downtime PostgreSQL migration strategy?▼

A safe PostgreSQL migration strategy uses zero-downtime rollout plans with robust rollback procedures, ensuring data integrity and safe schema updates throughout the migration process.

Can I use EF Core migrations with PostgreSQL?▼

Yes, EF Core integrates with PostgreSQL by providing tailored migration workflows and schema design considerations to align entity models with PostgreSQL database constraints.

What are the best practices for PostgreSQL schema design and data integrity?▼

PostgreSQL schema design best practices involve structuring tables with appropriate data types and constraints to enforce data integrity and optimize overall database performance.

When should I use table partitioning in PostgreSQL?▼

Table partitioning in PostgreSQL should be applied during schema design and performance tuning to manage large datasets efficiently and improve query execution times.

Related Skills

Explore More Software Engineering Skills→
rabbicserabbicse

database-optimizer

Optimize slow PostgreSQL and MySQL queries with EXPLAIN ANALYZE validation.

Community
Advanced
BFLabsAIBFLabsAI

supabase-postgres-best-practices

Identify and prioritize Postgres performance improvements for Supabase deployments.

Community
Advanced
DevExpressDevExpress
39

devexpress-xaf-business-model

Implement XAF business model classes for .NET with EF Core or XPO.

Official
Advanced
AratKruglikAratKruglik
150

postgresql-optimization

Optimize PostgreSQL queries, indexes, and configuration parameters.

Community
Advanced