skills.rest
seqis
seqisCOMMUNITY
Explore all skills by this author →
GitHub

agent-database-specialist

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

Updated Aug 23, 2026
Search Tags:#query optimization#SQL#schema design#database#NoSQL#migration
One-click install
npx skills add https://github.com/seqis/OpenClaw-Skills-Converted-From-Claude-Code --skill agent-database-specialist
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: agent-database-specialist
Source: https://github.com/seqis/OpenClaw-Skills-Converted-From-Claude-Code/tree/main/skills_tree/agent-database-specialist
Command: npx skills add https://github.com/seqis/OpenClaw-Skills-Converted-From-Claude-Code --skill agent-database-specialist

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses complex database challenges, including schema design, query optimization, and safe migration procedures, ensuring data integrity and performance.

Core Features & Use Cases

  • Schema Design: Expert guidance on normalization, data types, and constraints for SQL and NoSQL databases.
  • Query Optimization: Strategies to improve query speed using indexing, rewriting, and caching.
  • Migration Safety: Protocols for zero-downtime migrations and rollback procedures.
  • Healthcare Imaging: Specific patterns for DICOM hierarchy and indexing.

Quick Start

Use the agent-database-specialist skill to design a PostgreSQL schema for patient, study, and series data.

Frequently Asked Questions about agent-database-specialist

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

FAQPage Schema
How do I optimize slow SQL queries against a large database?▼

To optimize slow SQL queries, apply strategies like adding targeted indexes, rewriting anti-patterns, and implementing caching to improve database query speed and maintainability.

What is the best way to design a schema for healthcare imaging data?▼

Designing a schema for healthcare imaging data requires structuring the DICOM hierarchy and applying specific indexing patterns to ensure data integrity and query performance.

How can I perform zero-downtime database migrations safely?▼

Zero-downtime database migrations require strict safety protocols and rollback procedures to prevent data loss, ensuring migration safety and continuous data availability.

Does this database schema design approach work for NoSQL platforms?▼

Yes, the database schema design guidance covers normalization, data types, and constraints for both SQL and NoSQL databases to ensure performance and data integrity.

What are common SQL query anti-patterns I should avoid?▼

Common SQL query anti-patterns degrade performance and are addressed through query rewriting, proper indexing, and caching strategies to maintain database efficiency.

Related Skills

Explore More Software Engineering Skills→
MarcoAvendanoMarcoAvendano
1

supabase-postgres-best-practices

Optimize PostgreSQL queries and schema design with Supabase best practices.

Community
Intermediate
AI-Foundry-CoreAI-Foundry-Core
4

database-migration

Execute database migrations across ORMs with rollback-safe procedures.

Official
Advanced
a53alia53ali

database-optimization

Analyze EXPLAIN ANALYZE output to resolve slow PostgreSQL queries.

Community
Advanced
curiositechcuriositech
181

performance-profiling

Analyze Node.js application performance via CPU profiling and database query analysis.

Official
Advanced