skills.rest
aiyuekuang
aiyuekuangCOMMUNITY
Explore all skills by this author →
GitHub

database

Design and optimize relational database schemas, queries, and migrations for PostgreSQL and MySQL.

14|4|Updated Jan 14, 2026
Search Tags:#design#performance#database#migrations#schema#sql
One-click install
npx skills add https://github.com/aiyuekuang/LLMProxy --skill database-aiyuekuang
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/aiyuekuang/LLMProxy/tree/main/.windsurf/skills/database
Command: npx skills add https://github.com/aiyuekuang/LLMProxy --skill database-aiyuekuang

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The Database Skill consolidates best practices for designing robust schemas, optimizing queries, and planning migrations to prevent costly refactors and performance bottlenecks.

Core Features & Use Cases

  • Schema design patterns and naming conventions for maintainable data models.
  • Query optimization guidance, indexing strategies, and safe migration workflows.
  • Use cases include designing a new multi-tenant schema, indexing critical tables, and evolving schemas with minimal downtime.

Quick Start

Draft a starter database design plan for a new app, including a sample schema and a migration strategy.

Frequently Asked Questions about database

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

FAQPage Schema
How do I design a scalable database schema for a multi-tenant application?▼

Designing a scalable database schema for a multi-tenant application requires applying structured naming conventions and scalable design patterns to maintain clear data models. This approach ensures reliable performance and maintainable schemas as your application grows.

What's the best way to optimize SQL queries and manage indexing strategies?▼

Optimizing SQL queries and managing indexing strategies involves applying performance best practices to critical tables. This process prevents performance bottlenecks by ensuring your PostgreSQL or MySQL databases maintain reliable query execution speeds.

How do I plan safe database migrations with minimal downtime?▼

Planning safe database migrations with minimal downtime requires implementing rollbackable workflows and validation checks. This approach allows you to evolve schemas safely in production-grade applications without causing disruptive outages.

Does this database design approach work with both PostgreSQL and MySQL projects?▼

Yes, this database design approach works directly with both PostgreSQL and MySQL projects. It applies relational database schema optimization and security-conscious data management techniques to ensure reliable performance across both platforms.

Why does my relational database schema need refactoring and how to prevent it?▼

Relational database schemas need refactoring due to poor initial design patterns and lack of indexing strategies, leading to performance bottlenecks. Consolidating best practices for robust schemas and query optimization prevents these costly refactors.

Related Skills

Explore More Software Engineering Skills→
CinderZhangCinderZhang
3

represent-datamodel

Define core system entities and their plain-language relationships.

Community
Basic
m16khbm16khb
1

codd

Analyze and optimize relational database schemas and SQL queries.

Community
Advanced
a35506322a35506322

map-feature-flow

Trace cross-stack code paths from feature, page, or API entry points.

Community
Intermediate
rodydavisrodydavis
58

how-to-store-sqlite-as-nosql-store

Store JSON documents in SQLite with TTL-based automatic expiration.

Community
Intermediate