← Back to Skills Marketplace
Database Operations
by
jgarrison929
· GitHub ↗
· v1.0.0
13324
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
Safe to install as a database helper, but review generated SQL before running it, especially migrations, dynamic SQL functions, audit logs that may copy sensitive fields, cache invalidation code, 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’s SQL, EF Core, Redis, indexing, migration, partitioning, and monitoring examples match its database-operations purpose; some examples would change real databases if a user applies them.
Instruction Scope
The description and triggers are broad, including generic database terms and EXPLAIN, which may cause over-invocation, but the runtime instructions remain database-focused and emphasize measurement and rollback.
Install Mechanism
The bundle contains a single non-executable SKILL.md artifact and no install scripts, binaries, package hooks, or hidden runtime files.
Credentials
The artifact does not request local file access, credentials, sessions, or network access; REDIS_URL appears only in an illustrative Redis code snippet.
Persistence & Privilege
The skill does not create agent persistence or request elevated privileges, though its sample database code includes persistent objects such as tables, indexes, triggers, functions, and materialized views.
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 13324 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