skills.rest
TheSoftwareHouse
TheSoftwareHouseOFFICIAL
Explore all skills by this author →
WebsiteGitHub

sql-and-database

Design relational database schemas and write SQL across PostgreSQL and MySQL.

282|20|Updated Jan 7, 2026
Search Tags:#indexing#sql#transactions#explain#database-design#normalisation
One-click install
npx skills add https://github.com/TheSoftwareHouse/copilot-collections --skill sql-and-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-and-database
Source: https://github.com/TheSoftwareHouse/copilot-collections/tree/main/.github/skills/sql-and-database
Command: npx skills add https://github.com/TheSoftwareHouse/copilot-collections --skill sql-and-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Design robust relational databases and write high-performance SQL consistently.

Core Features & Use Cases

  • Schema design conventions (naming, primary keys, foreign keys, indexes)
  • Normalisation strategies (1NF-3NF), denormalisation guidance
  • Performance optimization using EXPLAIN ANALYZE, indexing, and query patterns
  • Locking, transactions, and recovery patterns
  • ORM integration guidelines for popular frameworks (TypeORM, Prisma, Doctrine, Eloquent, EF, Hibernate, GORM)
  • Migration and versioning best practices

Quick Start

Provide a compliant database design blueprint for a new multi-tenant orders service following the guidelines.

Frequently Asked Questions about sql-and-database

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

FAQPage Schema
How do I design a normalized database schema for a multi-tenant service?▼

Database schema design for multi-tenant services involves applying 1NF-3NF normalization strategies, establishing naming conventions for primary and foreign keys, and planning versioned migrations to ensure robust relational structures.

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

SQL query optimization uses EXPLAIN ANALYZE to inspect execution plans, guiding indexing strategies and query pattern rewrites to resolve performance bottlenecks across PostgreSQL, MySQL, and other major database engines.

Does this database design approach work with ORMs like Prisma and TypeORM?▼

ORM integration guidelines support popular frameworks including Prisma, TypeORM, Doctrine, Eloquent, Entity Framework, Hibernate, and GORM, ensuring deterministic SQL patterns and safe schema changes align with ORM mapping behaviors.

How do I handle database transactions and locking patterns to prevent conflicts?▼

Database transaction and locking management provides recovery patterns and concurrency controls that maintain data integrity, ensuring safe execution of versioned migrations and deterministic SQL operations under concurrent load.

When should I use denormalization in my relational database design?▼

Denormalization guidance applies when normalized 1NF-3NF schemas create performance bottlenecks, allowing strategic data redundancy to optimize read-heavy query patterns while maintaining safe schema change protocols across major engines.

Related Skills

Explore More Software Engineering Skills→
HechaoYannetHechaoYannet

create-architecture

Generate a master architecture document from GDDs, ADRs, and governance constraints.

Community
Advanced
ahiendzahiendz
3

managing-database-migrations

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

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
DauQuangThanhDauQuangThanh
14

database-design

Design relational and NoSQL database schemas from business requirements.

Community
Advanced