ecosystem-database
🗄️ Database Domain Ecosystem
Welcome to the database domain ecosystem. This directory contains specialized agentic skills for database schema design, query optimization, data migration, and security (SQL & NoSQL).
For Orchestrator Agents (
task-decomposer,parallel-planner): When asked to plan a database-related task, you MUST consult the workflows below. Do not hallucinate steps; map your plan strictly to these available skills in the order defined.
🔄 Standard Workflows & Handoffs
1. New Schema Design Flow
When the user asks to "design a database", "create tables", or "model the data", execute these skills sequentially:
@schema-architect-> Creates the ERDs, tables, relationships, and normalizes the models.@access-policy-designer-> Designs Row-Level Security (RLS) or application-level access controls.@seed-data-generator-> Generates realistic, varied placeholder data for development and testing.
2. Performance Optimization Flow
When the user asks to "fix a slow query", "optimize the database", or "why is the DB lagging":
@query-explainer-> Analyzes the execution plans (e.g.,EXPLAIN ANALYZE) to locate bottlenecks.@index-advisor-> Recommends optimal covering indexes, composites, or partition keys to solve the bottleneck.@query-budget-enforcer-> Sets up mechanisms to detect and alert on N+1 queries or heavy reads in the future.
3. Database Evolution Flow
When the user asks to "update the database", "change a table", or "migrate data":
@schema-diff-analyzer-> Compares the old schema and new schema to detect potential data loss or locks.@migration-strategist-> Designs the zero-downtime migration scripts (up/down) and backfill jobs.
4. Compliance & Observability Flow
When the user asks about "data privacy", "GDPR", or "where does this data go":
@data-masker-> Identifies PII (Personally Identifiable Information) and designs obfuscation/encryption strategies.@data-lineage-tracer-> Maps how data flows from ingestion to the data warehouse.
5. Infrastructure & Scaling Flow
When the user asks to "scale database connections", "setup pgbouncer", "fix too many connections", or "configure connection pool":
@pgbouncer-architect-> Analyzes workload, calculates optimal pool sizes, selects pooling mode, and generates PgBouncer configurations.
🧠 Core Philosophy
Database design is focused on data integrity, scalable reads/writes, and strict security constraints. Every skill in this domain is programmed to defend against data corruption and insecure data exposure. Never prioritize feature delivery over data safety.
🚀 Installation & Orchestration Instructions
As an AI Agent reading this ecosystem file, you must actively guide the user to install the missing skills for the selected workflow.
To install all skills within this ecosystem at once, you must execute or instruct the user to execute the provided installation script:
python skills/ecosystem-database/scripts/install_all.py
Execution Rule: Do not attempt to perform the tasks of these skills yourself. Your job is to install them and hand off the execution to the appropriate skill, or instruct the user to trigger the newly installed skills in order.
More from fatih-developer/fth-skills
task-decomposer
Break down large, complex, or ambiguous tasks into independent subtasks with dependency maps, execution order, and success criteria. Plan first, then execute step by step. Triggers on 'how should I do this', 'where do I start', 'plan the project', 'break it down', 'implement' or whenever a task involves multiple phases.
24context-compressor
Compress long conversation histories, large code files, research results, and documents by 70% without losing critical information. Triggers when context window fills up, when summarizing previous steps in multi-step tasks, before loading large files into context, or on 'summarize', 'compress', 'reduce context', 'save tokens'.
17error-recovery
When a step fails during an agentic task, classify the error (transient, configuration, logic, or permanent), apply the right recovery strategy, and escalate to the user when all strategies are exhausted. Triggers on error messages, exceptions, tracebacks, 'failed', 'not working', 'retry', or when 2 consecutive steps fail.
12react-flow
Analyze, repair, migrate, and scaffold @xyflow/react codebases. Use when users ask to debug React Flow behavior, fix node/edge state wiring, improve type safety or performance, upgrade legacy React Flow APIs, preserve persisted graph compatibility, or generate a complete React Flow starter from scratch.
12multi-brain-experts
Replace generic perspectives with domain-specific expert roles selected dynamically per request. Automatically picks the 3 most relevant experts from a role pool (Security, Performance, UX, Cost, DX, Architecture, etc.) based on the task context.
12memory-ledger
Maintain a structured ledger of decisions, discovered bugs and fixes, user preferences, constraints, current status, and failed approaches throughout multi-step agentic tasks. Auto-update after every significant step. Triggers on 'where were we', 'continue', 'summarize status', 'remember', or when a new agent instance takes over a task.
11