skills.rest
ripgraphics
ripgraphicsCOMMUNITY
Explore all skills by this author →
GitHub

database-expert

Analyze database query plans and optimize performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Updated Apr 23, 2025
Search Tags:#performance#schema design#database#optimization#sql#orm#query tuning
One-click install
npx skills add https://github.com/ripgraphics/authorsinfo --skill database-expert-ripgraphics
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/ripgraphics/authorsinfo/tree/main/.cursor/skills/database-expert
Command: npx skills add https://github.com/ripgraphics/authorsinfo --skill database-expert-ripgraphics

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses challenges related to database performance, schema design, query optimization, connection management, and security across various database systems and ORMs.

Core Features & Use Cases

  • Query Performance Tuning: Analyzes and optimizes slow-running queries.
  • Schema Design & Migrations: Assists in designing efficient database schemas and managing migrations.
  • Connection & Transaction Management: Helps resolve issues with connection pooling, deadlocks, and transactions.
  • Indexing Strategies: Provides recommendations for effective indexing.
  • Security Audits: Reviews access controls and security configurations.
  • Use Case: If your application is experiencing slow load times due to inefficient database queries, this Skill can analyze your query plans, suggest appropriate indexes, and help rewrite queries for better performance.

Quick Start

Use the database-expert skill to analyze the performance of the 'SELECT * FROM users;' query in PostgreSQL.

Frequently Asked Questions about database-expert

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

FAQPage Schema
How do I optimize slow SQL queries in PostgreSQL or MySQL?▼

To optimize slow SQL queries, you must analyze query execution plans to identify bottlenecks, then apply targeted indexing strategies and rewrite the queries for better performance. This resolves application load delays caused by inefficient database operations.

What is the best way to design an efficient database schema and manage migrations?▼

Efficient database schema design requires structuring tables to minimize redundancy and maximize query speed, while managing migrations ensures controlled structural updates. Analyzing schema structures yields targeted solutions for schema efficiency and transaction integrity.

Does this database optimization approach work with MongoDB and SQLite?▼

Yes, this database optimization approach works with MongoDB and SQLite environments. It analyzes query plans and schema structures across these systems to provide targeted solutions for query speed, connection pooling, and indexing.

How do I resolve connection pooling issues and transaction deadlocks?▼

Resolving connection pooling issues and transaction deadlocks requires analyzing your database environment and connection management configurations. This analysis provides targeted solutions to restore transaction integrity and stabilize connection pooling.

Can I integrate ORM configurations with database query tuning?▼

Yes, you can integrate ORM configurations with database query tuning. Analyzing ORM configurations alongside query plans enables targeted solutions that bridge application-layer object mapping with underlying database performance optimization.

Related Skills

Explore More Software Engineering Skills→
Aqsagull99Aqsagull99

neon-db-skill

Automate Neon PostgreSQL operations with SQLAlchemy async connections and connection pooling.

Community
Intermediate
kensauruskensaurus
8

database-optimization

Profile slow queries and optimize indexes in PostgreSQL, Prisma, and Supabase.

Community
Advanced
bradtaylorsfbradtaylorsf
8

node-performance

Optimize Node.js performance with worker threads, LRU caching, and profiling.

Community
Advanced
erikhowarderikhoward

database-optimizer

Analyze execution plans and tune queries, indexes, and caching across PostgreSQL, MySQL, and SQL Server.

Community
Advanced