skills.rest
wyattowalsh
wyattowalshCOMMUNITY
Explore all skills by this author →
Website𝕏@wyattowalshGitHub

database-architect

Design, generate, and validate SQL schemas and migrations across PostgreSQL, MySQL, and SQLite.

4|1|Updated Jan 26, 2026
Search Tags:#performance#SQL#database#optimization#schema#migration#DDL
One-click install
npx skills add https://github.com/wyattowalsh/agents --skill database-architect-wyattowalsh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-architect
Source: https://github.com/wyattowalsh/agents/tree/main/skills/database-architect
Command: npx skills add https://github.com/wyattowalsh/agents --skill database-architect-wyattowalsh

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pypdf, pdfplumber, pdf2image, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the complex and error-prone process of designing, evolving, and optimizing database schemas, ensuring data integrity and performance.

Core Features & Use Cases

  • Schema Design: Generate DDL from natural language requirements.
  • Migration Generation: Create safe, reversible SQL migrations with rollback plans.
  • Query Optimization: Recommend indexes and analyze query performance.
  • Schema Review: Audit existing schemas and migrations for quality and safety.
  • Use Case: You need to add a new feature requiring a complex database schema change. Use this Skill to design the new tables, generate the migration script with zero-downtime considerations, and then review it for potential issues before deployment.

Quick Start

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

Frequently Asked Questions about database-architect

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

FAQPage Schema
How do I generate SQL database schemas from natural language requirements?▼

To generate SQL schemas from natural language, you define your data requirements in plain text and the system outputs DDL statements. This approach creates structured database tables while ensuring data integrity and performance from the start.

What is the best way to create safe database migrations with zero downtime?▼

Creating zero downtime database migrations requires generating safe, reversible SQL scripts with rollback plans. The system analyzes schema evolution to ensure deployments do not interrupt service, validating DDL changes before they reach production.

How do I optimize SQL query performance and recommend indexes?▼

Optimizing SQL query performance involves detailed analysis of your queries to recommend appropriate indexes. The system evaluates execution patterns and suggests schema adjustments to improve database efficiency across PostgreSQL, MySQL, and SQLite.

Does this database schema design approach support PostgreSQL, MySQL, and SQLite?▼

Yes, this database schema design approach supports PostgreSQL, MySQL, and SQLite. It handles specific engine idiom considerations for each platform, ensuring generated DDL and migrations are valid and optimized for your chosen database.

How do I audit existing database schemas and migrations for safety?▼

Auditing existing database schemas involves reviewing current DDL and migration scripts to identify potential quality and safety issues. The system analyzes schema evolution paths to detect risks before deployment.

Why do I need to review schema evolution before deploying database changes?▼

Reviewing schema evolution before deploying database changes prevents data loss and downtime. Analyzing DDL changes for zero downtime considerations ensures complex schema modifications are safe, reversible, and optimized for performance.

Related Skills

Explore More Software Engineering Skills→
DifanaDAPDifanaDAP

outlines

Generates structured text like JSON and regex using NLP models with Pydantic validation.

Community
Advanced
lookatitudelookatitude
6

backend-migration-writer

Write reversible database migrations with up/down scripts and data backfills.

Community
Advanced
heaptracetechnologyheaptracetechnology
13

contract-test

Automate API contract testing with schema validation and OpenAPI checks.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate