skills.rest
arcasilesgroup
arcasilesgroupOFFICIAL
Explore all skills by this author →
WebsiteGitHub

schema

Design database schemas and plan safe migrations for PostgreSQL, MySQL, and SQLite.

54|3|Updated Feb 4, 2026
Search Tags:#database#optimization#schema#migration#data modeling#sql#data lifecycle
One-click install
npx skills add https://github.com/arcasilesgroup/ai-engineering --skill schema-arcasilesgroup
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema
Source: https://github.com/arcasilesgroup/ai-engineering/tree/main/.agents/skills/schema
Command: npx skills add https://github.com/arcasilesgroup/ai-engineering --skill schema-arcasilesgroup

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines complex database engineering tasks, from initial schema design and data modeling to ensuring safe migrations, optimizing queries, and managing the data lifecycle.

Core Features & Use Cases

  • Schema Design & Data Modeling: Create and refine database schemas, ensuring normalization and referential integrity.
  • Safe Migrations: Plan and execute database schema changes with rollback strategies.
  • Query Optimization: Analyze and improve the performance of SQL queries.
  • Data Lifecycle Management: Implement retention and archival policies.
  • Use Case: Refactor a legacy database schema to improve performance and prepare for a new feature launch, ensuring all data is migrated safely.

Quick Start

Design a PostgreSQL schema for a blog application with posts, users, and comments.

Frequently Asked Questions about schema

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

FAQPage Schema
How do I plan a safe database migration with a rollback strategy?▼

Safe database migration requires analyzing schema changes and access patterns to execute step-by-step transformations with rollback strategies. This approach ensures data integrity by allowing reversion if failures occur during the migration process.

What's the best way to design a normalized database schema for PostgreSQL?▼

Designing a database schema requires analyzing data models, access patterns, and growth projections to ensure normalization and referential integrity. This creates optimal schemas for PostgreSQL, MySQL, or SQLite that support efficient queries and data lifecycle management.

How do I optimize slow SQL queries against my existing data models?▼

Query optimization analyzes your data models and access patterns to improve SQL performance. By evaluating schema design and growth projections, it identifies bottlenecks and refines SQL queries for faster data retrieval.

How do I implement data lifecycle management and archival policies?▼

Data lifecycle management implements retention and archival policies by analyzing data access patterns and growth projections. This structures your database schema to automatically age out or archive cold data, maintaining overall query performance.

Does this database schema design approach work with ORMs and SQLite?▼

Yes, this database schema design approach supports various ORMs and databases including SQLite, PostgreSQL, and MySQL. It analyzes data models to ensure your schema maintains referential integrity across these different platforms.

Related Skills

Explore More Software Engineering Skills→
jeremylongshorejeremylongshore
2.6k

modeling-nosql-data

Design NoSQL data models for MongoDB and DynamoDB schemas.

Community
Intermediate
george11642george11642
2

db-supabase

Execute SQL, apply migrations, and deploy edge functions via Supabase MCP tools.

Community
Intermediate
martinffxmartinffx
39

atelier-typescript-drizzle-orm

Define Drizzle ORM schemas and generate type-safe TypeScript queries.

Community
Advanced
MinhmiceMinhmice

database-specialist

Designs and migrates database schemas, policies and queries for SQL-based systems.

Community
Intermediate