← Back to Skills Marketplace
Database Operations
by
jgarrison929
· GitHub ↗
· v1.0.0
12116
Downloads
7
Stars
108
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
Safe to install as a database guidance skill. Review generated SQL before applying it to production, especially dynamic SQL functions, audit logs that may copy sensitive fields, destructive migrations, cache invalidation, and scheduled materialized-view refreshes.
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
Purpose & Capability
The skill provides schema design, migration, indexing, caching, monitoring, and EF Core examples that match its stated database-operations purpose; some examples can mutate databases if a user applies them.
Instruction Scope
The routing description and triggers are broad and may invoke the skill for many database-related prompts, but the runtime instructions stay within database implementation guidance and include rollback and measurement principles.
Install Mechanism
The bundle contains only SKILL.md, no executable scripts, package install steps, declared binaries, or hidden runtime files.
Credentials
The artifact does not request local files, credentials, sessions, or network access; references such as REDIS_URL appear only inside illustrative code examples.
Persistence & Privilege
The skill does not create agent persistence or request privileges, but its sample SQL includes persistent database objects such as tables, triggers, indexes, materialized views, and functions.
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 12116 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