skills.rest
mohitmishra786
mohitmishra786COMMUNITY
Explore all skills by this author →
Website𝕏@chessMan786GitHub

database

Design normalized database schemas, write SQL queries, and manage migration files.

Updated Feb 7, 2026
Search Tags:#performance#query optimization#SQL#schema design#database#migrations#PostgreSQL
One-click install
npx skills add https://github.com/mohitmishra786/aurora-dev --skill database-mohitmishra786
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/mohitmishra786/aurora-dev/tree/main/.agents/skills/database
Command: npx skills add https://github.com/mohitmishra786/aurora-dev --skill database-mohitmishra786

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines database management by automating schema design, query optimization, and migration processes, ensuring efficient and scalable data storage.

Core Features & Use Cases

  • Schema Design: Creates normalized database schemas (3NF baseline) with defined relationships and constraints.
  • Query Optimization: Analyzes and optimizes SQL queries using techniques like indexing and materialized views.
  • Migration Management: Generates and tests database migration files with up/down scripts.
  • Use Case: When developing a new feature that requires a new data model, use this Skill to design the optimal PostgreSQL schema, including necessary indexes and foreign key constraints.

Quick Start

Use the database skill to design a normalized schema for a blog with users, posts, and comments.

Frequently Asked Questions about database

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

FAQPage Schema
How do I design a normalized PostgreSQL schema for a new application feature?▼

Schema design creates normalized PostgreSQL schemas starting from a 3NF baseline, defining relationships and constraints to ensure efficient and scalable data storage for new application features.

What's the best way to optimize slow SQL queries using EXPLAIN ANALYZE?▼

Query optimization analyzes and improves slow SQL queries using EXPLAIN ANALYZE, applying techniques like adding necessary indexes and materialized views to reduce execution time.

How do I generate and manage database migration files with up and down scripts?▼

Migration management generates and tests database migration files equipped with up and down scripts, handling migration versioning to safely apply and rollback schema changes.

Can I use this approach for both SQL and NoSQL database schema design?▼

Yes, schema design and data modeling capabilities support various SQL and NoSQL databases, allowing you to apply normalization or denormalization strategies based on your specific database architecture.

When should I choose schema denormalization over normalization for performance?▼

Schema denormalization for performance is appropriate when read speed is critical and query complexity is high, trading redundant data storage for faster SQL query execution and optimized read operations.

Related Skills

Explore More Software Engineering Skills→
rsmdtrsmdt
381

data-modeling

Design database schemas from domain requirements with ER modeling and normalization.

Community
Advanced
ahiendzahiendz
3

managing-database-migrations

Generate, apply, and rollback versioned database migrations across PostgreSQL, MySQL, SQLite, and MongoDB.

Community
Advanced
darblexdarblex

Database Architect

Design, optimize, and plan migrations for database schemas and queries.

Community
Advanced
Thanh-aperoThanh-apero
1

databases

Guide MongoDB and PostgreSQL schema design, query optimization, and performance tuning.

Community
Advanced