skills.rest
mahamaneharouna9-cpu
mahamaneharouna9-cpuCOMMUNITY
Explore all skills by this author →
GitHub

database-expert

Optimize database performance and schema design across PostgreSQL, MySQL, MongoDB, and SQLite.

Updated Jan 21, 2026
Search Tags:#performance#database#optimization#schema#sql#orm#query
One-click install
npx skills add https://github.com/mahamaneharouna9-cpu/Apex-invoice-billing-automation --skill database-expert-mahamaneharouna9-cpu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/mahamaneharouna9-cpu/Apex-invoice-billing-automation/tree/main/.opencode/skill/database-expert
Command: npx skills add https://github.com/mahamaneharouna9-cpu/Apex-invoice-billing-automation --skill database-expert-mahamaneharouna9-cpu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

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

Core Features & Use Cases

  • Query Optimization: Analyzes and improves slow-running SQL queries.
  • Schema Design: Assists in creating efficient and scalable database schemas.
  • Connection Management: Helps in configuring and optimizing database connections and pooling.
  • Use Case: Troubleshoot a slow API endpoint by optimizing the database queries it relies on, or design a new database schema for a growing application.

Quick Start

Analyze the performance of the 'users' table in PostgreSQL and suggest indexing improvements.

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 PostgreSQL queries and improve database performance?▼

To optimize slow PostgreSQL queries, you analyze query execution plans, design efficient schemas, and implement proper indexing. This resolves slow queries by addressing inefficient SQL structures and missing indexes.

What is the best way to design a scalable database schema for a growing application?▼

Designing a scalable database schema involves structuring tables and relationships to minimize data redundancy and maximize query efficiency. This ensures your application handles growth without performance degradation.

Can I use this to troubleshoot ORM connection pooling and transaction handling issues?▼

Yes, you can troubleshoot ORM connection pooling and transaction handling issues. It provides configuration strategies for managing database connections effectively across PostgreSQL, MySQL, MongoDB, and SQLite.

Does query optimization work with both SQL and MongoDB databases?▼

Yes, query optimization works with both SQL and MongoDB databases. It analyzes and improves slow queries across PostgreSQL, MySQL, SQLite, and MongoDB by understanding database internals and query patterns.

Why does my API endpoint remain slow even after adding database indexes?▼

Your API endpoint may remain slow due to inefficient schema design, unoptimized ORM queries, or poor connection management. Analyzing database internals and transaction handling reveals bottlenecks beyond simple indexing.

Related Skills

Explore More Software Engineering Skills→
asgarovfasgarovf
23

database-sql

Design database schemas, write SQL queries, and create migrations.

Community
Intermediate
ThedouglerThedougler

openrouter-performance-tuning

Tune OpenRouter API configurations for reduced latency and increased throughput.

Community
Advanced
doanchienthangdevdoanchienthangdev
4

testing/performance-testing

Run load, stress, and benchmark tests with k6 and Node.js profilers.

Community
Advanced
TorbenMerraldTorbenMerrald
1

Backend Models

Define and enforce database models and entity schemas across ORM and migration scripts.

Community
Advanced