← 返回 Skills 市场
Database Operations
作者
jgarrison929
· GitHub ↗
· v1.0.0
13689
总下载
7
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install 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.
安全使用建议
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.
功能分析
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.
能力评估
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.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install database-operations - 安装完成后，直接呼叫该 Skill 的名称或使用
/database-operations触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
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.
元数据
常见问题
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. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 13689 次。
如何安装 Database Operations？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install database-operations」即可一键安装，无需额外配置。
Database Operations 是免费的吗？
是的，Database Operations 完全免费（开源免费），可自由下载、安装和使用。
Database Operations 支持哪些平台？
Database Operations 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Database Operations？
由 jgarrison929（@jgarrison929）开发并维护，当前版本 v1.0.0。
推荐 Skills