skills.rest
iceflower
iceflowerCOMMUNITY
Explore all skills by this author →
GitHub

database

Standardize database migrations, query optimization, and transaction management rules.

1|Updated Mar 16, 2026
Search Tags:#performance#database#optimization#migration#sql#transactions
One-click install
npx skills add https://github.com/iceflower/opencode-agents-and-skills --skill database-iceflower
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/iceflower/opencode-agents-and-skills/tree/main/skills/database
Command: npx skills add https://github.com/iceflower/opencode-agents-and-skills --skill database-iceflower

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance on database design, migration, query optimization, and transaction management, helping you build robust and efficient data systems.

Core Features & Use Cases

  • Migration Conventions: Standardize database schema changes with clear naming and idempotency rules.
  • Query Optimization: Improve application performance by applying best practices for indexing and query writing.
  • Transaction Management: Ensure data integrity and prevent deadlocks with clear transaction scoping rules.
  • Anti-Pattern Avoidance: Learn to recognize and avoid common pitfalls that lead to performance issues and data corruption.
  • Use Case: When designing a new feature that requires database interaction, consult this Skill for best practices on creating migration files, writing efficient queries, and managing transactions to ensure data consistency and application speed.

Quick Start

Apply the database skill to create a new migration file named V5__add_user_profiles_table.sql.

Frequently Asked Questions about database

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

FAQPage Schema
How do I standardize database migration file naming and ensure idempotency?▼

Database migration standardization requires applying framework-agnostic naming conventions and idempotency rules to schema changes. This prevents conflicts and ensures consistent database state across deployments.

What are the best practices for SQL query optimization and indexing?▼

SQL query optimization involves applying indexing guidelines and query writing best practices to improve application performance. This approach targets query efficiency and reduces common performance bottlenecks.

How does transaction scoping prevent deadlocks and ensure data integrity?▼

Transaction scoping prevents deadlocks and ensures data integrity by defining clear boundaries for database transactions. Proper scoping manages concurrent access and maintains consistent data states.

Can I use these database optimization rules with any framework?▼

Yes, you can use these database optimization rules with any framework because they are framework-agnostic. They provide standardized guidelines for migrations, queries, and transactions regardless of platform.

What common database anti-patterns lead to performance issues and data corruption?▼

Common database anti-patterns causing performance issues and data corruption include improper indexing, poor transaction scoping, and non-idempotent migrations. Recognizing these pitfalls ensures application speed and data integrity.

Related Skills

Explore More Software Engineering Skills→
botPhUbotPhU

database-expert

Analyze SQL and NoSQL workloads and produce prioritized database optimization plans.

Community
Advanced
paultyngpaultyng
9

review-database

Review PostgreSQL and MySQL migrations, queries, and schema designs.

Community
Advanced
paulinghampaulingham
1

db-migration

Automate end-to-end database migrations across major ORMs and frameworks.

Community
Advanced
HieubkavHieubkav

database-backup

Automate pre-migration database backups with Spatie Laravel Backup.

Community
Basic