database-operations

Name: database-operations
Availability: InStock
Author: zangxin75

Optimize PostgreSQL queries with EXPLAIN ANALYZE and Redis caching.

Updated Mar 1, 2026

Search Tags:#performance #SQL #schema design #database #migrations #optimization #PostgreSQL

Ready to run

npx skills add https://github.com/zangxin75/openclaw-skills --skill database-operations-zangxin75

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-operations
Source: https://github.com/zangxin75/openclaw-skills/tree/main/database-operations
Command: npx skills add https://github.com/zangxin75/openclaw-skills --skill database-operations-zangxin75

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines complex database tasks, from initial schema design and migration to advanced query optimization and performance tuning, ensuring your database is efficient and robust.

Core Features & Use Cases

Schema Design & Migrations: Create and manage database schemas, write safe migrations, and implement patterns like soft deletes and audit trails.
Query Optimization: Analyze query performance using EXPLAIN ANALYZE, strategically add indexes, and identify slow queries.
Database Performance: Configure connection pools, implement caching strategies with Redis, and manage table partitioning.
Use Case: Optimize a slow-running e-commerce backend by analyzing EXPLAIN ANALYZE output for key queries, adding appropriate indexes, and implementing a Redis cache for frequently accessed product data.

Quick Start

Design a PostgreSQL schema for user management including status, email verification, and soft delete capabilities.

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 queries using EXPLAIN ANALYZE?▼

To optimize slow PostgreSQL queries, use EXPLAIN ANALYZE to review query execution plans, identify bottlenecks like sequential scans, and strategically add indexes to improve performance. This Skill guides you through analyzing output and resolving N+1 query issues.

What's the best way to design a PostgreSQL schema with soft delete capabilities?▼

Designing a PostgreSQL schema with soft deletes involves adding specific columns to track deletion status and timestamps. This Skill provides guidance on creating schemas, writing safe migrations, and implementing audit trails for robust data management.

How do I configure connection pools and implement Redis caching for database performance?▼

Configuring connection pools and implementing Redis caching improves database performance by reducing direct query loads. This Skill covers setting up connection pooling parameters and integrating Redis caching strategies for frequently accessed data.

Can I manage EF Core migrations and implement table partitioning with this guidance?▼

Yes, you can manage EF Core migrations and implement table partitioning. This Skill covers EF Core migration best practices and advanced PostgreSQL performance tuning techniques including table partitioning for large datasets.

Why does my database have N+1 query issues and how do I resolve them?▼

N+1 query issues occur when an application executes individual queries for related records instead of batch loading. This Skill helps you identify N+1 patterns using query analysis and resolve them through optimized schema design and indexing strategies.

Nick777-Pixel