skills.rest
mattstyles333
mattstyles333COMMUNITY
Explore all skills by this author →
GitHub

database-operations

Optimize PostgreSQL SQL queries and manage EF Core schema migrations.

Updated Feb 22, 2026
Search Tags:#caching#SQL#schema design#database#migrations#optimization#PostgreSQL
One-click install
npx skills add https://github.com/mattstyles333/openclaw-workspace --skill database-operations-mattstyles333
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-operations
Source: https://github.com/mattstyles333/openclaw-workspace/tree/main/skills/database-operations
Command: npx skills add https://github.com/mattstyles333/openclaw-workspace --skill database-operations-mattstyles333

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses complex database challenges, from initial schema design and migration to performance optimization and advanced configurations like partitioning and caching.

Core Features & Use Cases

  • Schema Design & Migrations: Create robust database schemas and manage migrations safely.
  • Query Optimization: Analyze and improve the performance of SQL queries, identify N+1 problems, and optimize indexing.
  • Advanced Techniques: Implement table partitioning, caching strategies (Redis), and EF Core best practices.
  • Use Case: Optimize a slow-running PostgreSQL query by analyzing its execution plan, adding appropriate indexes, and potentially implementing a caching layer.

Quick Start

Analyze the performance of the provided SQL query using EXPLAIN ANALYZE.

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 and analyze execution plans?▼

To optimize slow PostgreSQL queries, you analyze performance using EXPLAIN ANALYZE to identify bottlenecks, add appropriate indexing strategies, and resolve N+1 query problems for improved database execution speed.

What is the best way to design database schemas and manage migrations safely?▼

Designing database schemas and managing migrations safely involves creating robust relational structures and applying migration management best practices to ensure data integrity during structural database changes.

How do I detect and fix N+1 query problems in EF Core?▼

Detecting and fixing N+1 query problems in EF Core requires analyzing SQL query execution behavior to identify redundant data fetching, allowing you to apply optimized query loading patterns for better performance.

When do I need table partitioning and Redis caching for database optimization?▼

You need table partitioning and Redis caching for database optimization when addressing large dataset bottlenecks, implementing advanced configurations to distribute data load and reduce direct query execution overhead.

Does this database optimization approach work without external caching dependencies?▼

Yes, database optimization can be achieved through SQL query optimization, indexing strategies, and table partitioning directly within PostgreSQL, though implementing Redis caching provides an additional layer for performance scaling.

Related Skills

Explore More Software Engineering Skills→
imMamdouhaboammarimMamdouhaboammar

agency-database-optimizer

Analyze EXPLAIN ANALYZE plans to optimize PostgreSQL, MySQL, and Supabase queries.

Community
Advanced
ricardorochericardoroche
2

query-optimization

Optimize SQLAlchemy PostgreSQL queries with EXPLAIN ANALYZE, indexes, and eager loading.

Community
Intermediate
bugrabilgebugrabilge
10

caching-patterns

Guide caching strategies across browser, CDN, Redis, database, and framework layers.

Community
Advanced
MinhmiceMinhmice

database-specialist

Designs and migrates database schemas, policies and queries for SQL-based systems.

Community
Intermediate