skills.rest
Minhmice
MinhmiceCOMMUNITY
Explore all skills by this author →
GitHub

database-specialist

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

Updated Mar 22, 2026
Search Tags:#performance#SQL#database#schema#migration#policy
One-click install
npx skills add https://github.com/Minhmice/Thuocare --skill database-specialist-minhmice
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-specialist
Source: https://github.com/Minhmice/Thuocare/tree/main/.cursor/agents/specialists/database-specialist
Command: npx skills add https://github.com/Minhmice/Thuocare --skill database-specialist-minhmice

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the process of designing, maintaining, and securing database schemas, ensuring data integrity and performance.

Core Features & Use Cases

  • Schema Design & Migration Planning: Assists in developing new database schemas, facilitating safe migrations and rollbacks.
  • Policy & Query Optimization: Updates Row-Level Security policies and query strategies for improved performance and security.
  • Use Case: When a new table needs to be added or access policies updated, this Skill guides the data engineer through establishing safe and efficient database changes.

Quick Start

Use the database-specialist skill to plan a schema change for the patient records table.

Frequently Asked Questions about database-specialist

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

FAQPage Schema
How do I safely plan a database schema migration?▼

Plan a database schema migration by developing new schemas and establishing version control strategies for safe migrations and rollbacks. This ensures data integrity and secure data management during structural database changes.

What is the best way to optimize SQL query performance?▼

Optimize SQL query performance by updating query strategies and analyzing SQL plans to improve execution. This approach enhances database reliability and ensures efficient data retrieval for complex queries.

How do I update Row-Level Security policies for access control?▼

Update Row-Level Security policies by revising access control strategies within the database schema. This ensures secure data management by restricting data access based on defined user roles and policy constraints.

Can I use this for designing a new database schema from scratch?▼

Yes, you can use this for designing a new database schema from scratch. It guides data engineers through establishing safe and efficient database changes, ensuring data integrity and performance optimization.

What should I do if my database schema changes are causing performance issues?▼

If database schema changes cause performance issues, analyze SQL query plans and update query strategies. This addresses performance bottlenecks and ensures reliable data management after structural modifications.

Related Skills

Explore More Software Engineering Skills→
algusaemalgusaem

sql-optimization-patterns

Identify and apply SQL optimization patterns for PostgreSQL and MySQL queries.

Community
Advanced
pacphipacphi
6

database-testing

Validate database schemas, data integrity, migrations, and ACID properties.

Community
Intermediate
iludeilude
8

database-workflow

Provide language-agnostic best practices for database migrations, schema design, and query optimization.

Community
Advanced
Elevaria-biaElevaria-bia

aiox-data-engineer

Design Supabase and PostgreSQL schemas with RLS policies and safe migrations.

Community
Advanced