← Back to Skills Marketplace
Database Operations
by
jgarrison929
· GitHub ↗
· v1.0.0
13689
Downloads
7
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install database-operations
Description
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.
Usage Guidance
Review this skill before installing if you expect agents to generate production database code. Do not copy the audit trigger as written for tables containing password hashes, tokens, secrets, MFA data, or personal data; use explicit allowlists or field exclusions. Treat migration and EF update commands as templates only after confirming the target environment, backups, generated SQL, staging results, and rollback plan.
Capability Analysis
Type: OpenClaw Skill
Name: database-operations
Version: 1.0.0
The skill bundle provides comprehensive documentation and code examples for database operations, including schema design, query optimization, migrations, caching, and monitoring. All content, including SQL, C#, and TypeScript code snippets, aligns with the stated purpose of a database specialist skill. There are no instructions for the AI agent to perform malicious actions, exfiltrate data, or engage in prompt injection. Shell commands for `dotnet ef` and environment variable access (`process.env.REDIS_URL`) are presented as code examples for the agent to learn from, not as direct execution commands for the agent itself, consistent with an `output-format: code` skill.
Capability Assessment
Credentials
Database mutation guidance is proportional to the stated purpose, but examples include DROP COLUMN and direct dotnet ef database update commands without enough environment confirmation, backup, review, and rollback guardrails for production use.
Install Mechanism
The artifact is a single Markdown skill file with no executable scripts, dependencies, install hooks, remote payload retrieval, or package metadata requiring elevated install behavior.
Instruction Scope
The instructions are mostly database-focused and contain no role-change or system-override behavior. The trigger list includes broad terms such as database, schema, SQL, index, and EXPLAIN, which could activate the skill outside a clearly intended database-operations request.
Persistence & Privilege
The skill does not install agent persistence, background workers, services, cron jobs, or privilege escalation. Some SQL examples create durable database objects such as triggers, indexes, views, and materialized views, which is expected for the topic but should be applied only with review.
Purpose & Capability
The purpose is database design, migrations, query optimization, caching, and EF Core guidance, which matches most of the artifact. However, the audit-log example serializes entire user rows containing password_hash into JSONB audit records, creating a sensitive-data exposure risk if copied.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install database-operations - After installation, invoke the skill by name or use
/database-operations - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of database-operations skill.
- Provides expert guidance on database schema design, migrations, and performance optimization.
- Supports PostgreSQL, SQL query tuning, index strategies, EF Core migrations, caching (Redis/materialized views), and table partitioning.
- Includes code patterns for user management, audit logging, soft deletes, full-text search, and migration best practices.
- Offers recommended query analysis workflows, index optimization, N+1 detection, and migration rollback strategies.
Metadata
Frequently Asked Questions
What is Database Operations?
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question. It is an AI Agent Skill for Claude Code / OpenClaw, with 13689 downloads so far.
How do I install Database Operations?
Run "/install database-operations" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Database Operations free?
Yes, Database Operations is completely free (open-source). You can download, install and use it at no cost.
Which platforms does Database Operations support?
Database Operations is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Database Operations?
It is built and maintained by jgarrison929 (@jgarrison929); the current version is v1.0.0.
More Skills