Database Operations

Database Operations is a standalone skill that teaches any OpenClaw agent how to design schemas, write safe migrations, optimize queries, and manage databases in production — not just basic CRUD, but the operational knowledge that keeps data safe, queries fast, and migrations non-destructive. Most agents can write a SELECT statement. This skill teaches them to design the schema, index it properly, migrate it safely, and back it up before something goes wrong.

Drop this skill into any OpenClaw persona's skills folder and your agent immediately knows how to design normalized schemas with proper relationships, write migrations that don't break production, add indexes that actually speed up the right queries, manage connection pools, and implement backup strategies.

🗄️ Everything Included This skill covers the full database operations lifecycle — no separate purchases needed:

Schema Design — tables, relationships, data types, ID strategies, and naming conventions that scale Migrations — forward-only migrations, safe destructive changes, and the multi-step process for production schema updates Query Patterns — CRUD, joins, aggregations, pagination, and parameterized queries that prevent SQL injection Indexing — when to index, which type to use, composite indexes, partial indexes, and EXPLAIN for diagnosis Production Operations — connection pooling, backup strategies, and database selection guidance

Proven patterns:

Schema design with proper types, constraints, and indexes from day one Safe migration patterns that don't lock tables or break running code Query optimization using EXPLAIN to find and fix slow queries Connection pooling sized correctly for your application

What makes this different from database tutorials:

Production focus — patterns designed for real databases with real data, not empty dev databases Migration safety — the multi-step process for destructive changes that prevents downtime Security built in — parameterized queries by default, connection management, encrypted backups Database selection guide — when to use PostgreSQL vs SQLite vs Redis vs MongoDB Agent-native — structured for LLM consumption so your agent manages databases autonomously Anti-patterns included — the 8 most common database mistakes that cause data loss, slow queries, and security breaches

Includes SKILL.md with complete database documentation covering schema design, migrations, query patterns, indexing, connection management, backups, database selection, and anti-patterns. Designed for OpenClaw. Works with any persona that needs to work with persistent data.