skills.rest
cin12211
cin12211COMMUNITY
Explore all skills by this author →
GitHub

database-expert

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

218|14|Updated Apr 5, 2025
Search Tags:#performance#database#optimization#orm#multi-database#schema-design#query-analysis
One-click install
npx skills add https://github.com/cin12211/orca-q --skill database-expert
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/cin12211/orca-q/tree/main/.agent/skills/database-expert
Command: npx skills add https://github.com/cin12211/orca-q --skill database-expert

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses the challenge of optimizing performance, designing robust schemas, and analyzing complex queries across PostgreSQL, MySQL, MongoDB, and SQLite, with ORM integration.

Core Features & Use Cases

  • Performance optimization across multiple database systems including indexing strategies and query analysis.
  • Schema design & ORM integration to align data models with application architectures.
  • Cross-DB guidance for connection management, transactions, and architecture decisions in real-world projects.

Quick Start

Use this skill to assess current database setups, identify bottlenecks, and outline concrete optimization steps for your environment.

Frequently Asked Questions about database-expert

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

FAQPage Schema
How do I optimize database performance across PostgreSQL, MySQL, MongoDB, and SQLite?▼

Optimize database performance by applying indexing strategies, query analysis, and connection management to resolve bottlenecks across PostgreSQL, MySQL, MongoDB, and SQLite environments.

What is the best way to design database schemas with ORM integration?▼

Schema design with ORM integration aligns data models with application architectures to ensure robust structures across multiple database systems while satisfying validation and safe operational practices.

Can I use this for database query analysis and connection management in enterprise systems?▼

Yes, it supports database query analysis and connection management from small apps to enterprise systems, categorizing problems and detecting environments to outline concrete optimization steps.

How do I assess my current database setup and identify performance bottlenecks?▼

Assess current database setups by detecting the environment, categorizing problems, and validating safe operational practices to identify bottlenecks and outline actionable optimization steps.

Does cross-database guidance cover transactions and architecture decisions for real-world projects?▼

Cross-database guidance covers transactions, connection management, and architecture decisions to align data models with application architectures in real-world projects across diverse database environments.

Related Skills

Explore More Software Engineering Skills→
diendhdiendh

database-expert

Analyze and optimize database performance across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration.

Community
Advanced
augustsclaugustscl
2

supabase-postgres-best-practices

Optimize Postgres queries and schemas with SQL examples and EXPLAIN guidance.

Community
Advanced
bughqbughq
2

stacks-orm

Define database models and execute queries with Stacks ORM.

Official
Advanced
curiositechcuriositech
181

performance-profiling

Analyze Node.js application performance via CPU profiling and database query analysis.

Official
Advanced