agentCLAWHUBUnverified

sql-linker

Use this skill whenever you need to query, insert, update, or delete database records. Triggers include: (1) querying database data with SELECT statements an... Skill: sql-linker Owner: cloudcode-hans Summary: Use this skill whenever you need to query, insert, update, or delete database records. Triggers include: (1) querying database data with SELECT statements an... Tags: latest:1.3.2 Version history: v1.3.2 | 2026-06-27T07:34:51.507Z | user sql-linker 1.3.2 - Removed the skill card file (skill-card.md), which may affect documentation or marketplace display. - No changes t

OpenClaw

Rank

62

Safety

84

Downloads

1.9k

Updated

Oct 9, 2026

Version

1.3.2

Source

CLAWHUB

About

What it does, and when to use it.

Capability contract not published. No trust telemetry is available yet. 1.9K downloads reported by the source. Last updated 10/9/2026.

Avoid when

  • Contract metadata is missing or unavailable for deterministic execution.

Risk flags: missing_or_unavailable_contract, trust_data_unavailable, schema_references_missing

Public facts

Every fact links back to the source it came from.

Vendor
Clawhubvendor · observed Oct 9, 2026
Protocol compatibility
OpenClawcompatibility · observed Oct 9, 2026
Adoption signal
1.9K downloadsadoption · observed Oct 9, 2026
Latest release
1.3.2release · observed Jun 27, 2026
Handshake status
UNKNOWNsecurity

Install and run

Setup complexity: low.

clawhub skill install s176p0fdnm9khs6p3rx9vvyds583j95x:sql-linker
  1. Setup complexity is classified as HIGH. You must provision dedicated cloud infrastructure or an isolated VM. Do not run this directly on your local workstation.
  2. Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data.

Contract: missing

curl -s "https://www.xpersona.co/api/v1/agents/clawhub-cloudcode-hans-sql-linker/snapshot"

Documentation

CLAWHUB

151,788 characters of source documentation, loaded on request.

Extracted files

3 files captured from the source.

SKILL.md

---
name: sql-linker
version: "1.3.0"
description: "Use this skill when you need to query, insert, update, or delete records in the configured MySQL/PostgreSQL/SQLite database and you know the target table name and approximate schema. Triggers include: (1) explicitly requesting a SELECT/INSERT/UPDATE/DELETE on a named table; (2) asking for a specific record by ID or a specific filter; (3) requesting audit log review for sql_audit_log; (4) explicitly asking to bootstrap or inspect the sql-linker configuration. Do NOT trigger on generic "database", "查数据库", "SQL", or "CRUD" without a specific target table or intent."
requires:
  python_packages:
    - mysql-connector-python  # MySQL support
    - pymysql                # MySQL support (alternative)
    - psycopg2               # PostgreSQL support
    - pyyaml                 # Config file parsing
    - pywin32                # Windows DPAPI password decryption (optional; without this, password_dpapi is unavailable)
---

> **Important:** All `scripts/` paths are relative to this skill directory.
> Run with: `cd {skill_dir} && python scripts/...` or use the `cwd` parameter.

***

## sql-linker vs sql-linker-cli

### 中文

**sql-linker** 适用于本地开发和快速原型。对于**生产环境**,强烈推荐使用 **sql-linker-cli**。

| 对比项 | sql-linker | sql-linker-cli |
|-------|-----------|----------------|
| **dbpw_key 存储** | 本地存储在 `config.yaml` 中 | **云端管理**,通过 API Key 自动拉取 |
| **凭证密钥隔离** | 本地存储,OpenClaw 可能读取 | **本地与云端隔离**,密钥不在本地 |
| **凭证审批闸门** | 可选配置 | 默认开启,敏感操作需显式授权 |
| **使用场景** | 本地开发、快速原型 | **生产环境推荐**,安全优先 |
| **API Key 管理** | 无 | 云端统一管理,支持 Key 轮换 |
| **审计同步** | 本地 | 云端统一审计 |

**sql-linker 的局限性:**
- `dbpw_key` 存储在本地 `config.yaml`,OpenClaw agent 可能读取配置文件获取密钥
- 凭证审批闸门需要手动配置开启
- 审计日志存储在本地数据库

**生产环境推荐:**
- 迁移到 [sql-linker-cli](https://clawhub.ai/cloudcode-hans/skills/sql-linker-cli),享受云端密钥管理和统一审计

### English

**sql-linker** is suitable for local development and quick prototypes. For **production environments**, **sql-linker-cli** is strongly recommended.

| Feature | sql-linker | sql-linker-cli |
|---------|-----------|----------------|
| **dbpw_key storage** | Stored locally in `config.yaml` | **Cloud-managed**, auto-fetched via API Key |
| **Credential isolation** | Local storage, OpenClaw may access | **Local-cloud isolated**, key not on disk |
| **Credential approval gate** | Optional config | Enabled by default, explicit approval required |
| **Use case** | Local dev, quick prototypes | **Production recommended**, security-first |
| **API Key management** | None | Cloud unified management, supports rotation |
| **Audit sync** | Local | Cloud unified audit |

**sql-linker limitations:**
- `dbpw_key` stored locally in `config.yaml`, OpenClaw agent may read config to obtain key
- Credential approval gate requires manual configuration to enable
- Audit logs stored in local database

**Production recommendation:**
- Migrate to [sql-linker-cli](https://clawhub.ai/cloudcode-hans/skills/sql-linker-cli) for cloud key management and unified audit

_meta.json

{
  "ownerId": "kn76zmreha127n33hcnaknnmd5834x16",
  "slug": "sql-linker",
  "version": "1.3.2",
  "publishedAt": 1782545691507
}

skill-card.md

## Description:

Use this skill when you need to query, insert, update, or delete records in a configured MySQL, PostgreSQL, or SQLite database and you know the target table name and approximate schema.

This skill is ready for commercial/non-commercial use.

## Publisher:

[cloudcode-hans](https://clawhub.ai/user/cloudcode-hans)

### License/Terms of Use:

MIT-0

## Use Case:

Developers and agents use this skill to perform targeted CRUD operations and audit-log review against configured relational databases when a specific table or intent is known. It is suitable for local development and controlled database workflows that require explicit schema and configuration boundaries.

### Deployment Geography for Use:

Global

## Known Risks and Mitigations:

Risk: Database access controls and credential handling are weaker than the skill's security claims.

Mitigation: Install only for local development or tightly controlled databases, use a least-privilege database account, and keep read-only mode enabled until write access is explicitly needed.

Risk: Generated or configured credentials can be exposed when local configuration and environment values are available to the agent in the same trust boundary.

Mitigation: Prefer a proper secret manager over the generated dbpw_key and environment setup, and enable explicit credential approval before credential-backed connections.

Risk: Table allowlists and extra table configuration should not be treated as a hard security boundary.

Mitigation: Restrict database permissions at the database account level and review requested SQL operations before execution, especially INSERT, UPDATE, and DELETE.

## Reference(s):

- [sql-linker ClawHub page](https://clawhub.ai/cloudcode-hans/skills/sql-linker)
- [sql-linker-cli production alternative](https://clawhub.ai/cloudcode-hans/skills/sql-linker-cli)

## Skill Output:

**Output Type(s):** [text, code, shell commands, configuration, guidance]

**Output Format:** [Markdown with inline code, shell commands, configuration examples, and returned query or audit data]

**Output Parameters:** [1D]

**Other Properties Related to Output:** [May create local configuration files and return database rows, affected-row counts, audit records, or setup guidance depending on the requested operation.]

## Skill Version(s):

1.3.2 (source: server release metadata; artifact frontmatter says 1.3.0)

## Ethical Considerations:

Users should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.
Github ReposUpdated 9h agoRank 70

AionUi

Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!

MCPOPENCLAW
Github ReposUpdated 6mo agoRank 70

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

OPENCLAW
Github ReposUpdated 6mo agoRank 70

cherry-studio

AI productivity studio with smart chat, autonomous agents, and 300+ assistants.

MCPOPENCLAW
Github ReposUpdated 7mo agoRank 70

CopilotKit

The Frontend for Agents & Generative UI. React + Angular

OPENCLAW

Machine-readable data

The same record, as JSON, for agents and crawlers.

{
  "facts": [
    {
      "factKey": "vendor",
      "category": "vendor",
      "label": "Vendor",
      "value": "Clawhub",
      "href": "https://clawhub.ai/cloudcode-hans/skills/sql-linker",
      "sourceUrl": "https://clawhub.ai/cloudcode-hans/skills/sql-linker",
      "sourceType": "profile",
      "confidence": "medium",
      "observedAt": "2026-10-09T23:21:32.351Z",
      "isPublic": true
    },
    {
      "factKey": "protocols",
      "category": "compatibility",
      "label": "Protocol compatibility",
      "value": "OpenClaw",
      "href": "https://www.xpersona.co/api/v1/agents/clawhub-cloudcode-hans-sql-linker/contract",
      "sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-cloudcode-hans-sql-linker/contract",
      "sourceType": "contract",
      "confidence": "medium",
      "observedAt": "2026-10-09T23:21:32.351Z",
      "isPublic": true
    },
    {
      "factKey": "traction",
      "category": "adoption",
      "label": "Adoption signal",
      "value": "1.9K downloads",
      "href": "https://clawhub.ai/cloudcode-hans/sql-linker",
      "sourceUrl": "https://clawhub.ai/cloudcode-hans/sql-linker",
      "sourceType": "profile",
      "confidence": "medium",
      "observedAt": "2026-10-09T23:21:32.351Z",
      "isPublic": true
    },
    {
      "factKey": "latest_release",
      "category": "release",
      "label": "Latest release",
      "value": "1.3.2",
      "href": "https://clawhub.ai/cloudcode-hans/sql-linker",
      "sourceUrl": "https://clawhub.ai/cloudcode-hans/sql-linker",
      "sourceType": "release",
      "confidence": "medium",
      "observedAt": "2026-06-27T07:34:51.507Z",
      "isPublic": true
    },
    {
      "factKey": "handshake_status",
      "category": "security",
      "label": "Handshake status",
      "value": "UNKNOWN",
      "href": "https://www.xpersona.co/api/v1/agents/clawhub-cloudcode-hans-sql-linker/trust",
      "sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-cloudcode-hans-sql-linker/trust",
      "sourceType": "trust",
      "confidence": "medium",
      "observedAt": null,
      "isPublic": true
    }
  ],
  "events": [
    {
      "eventType": "release",
      "title": "Release 1.3.2",
      "description": "sql-linker 1.3.2 - Removed the skill card file (`skill-card.md`), which may affect documentation or marketplace display. - No changes to core logic or configuration; usage and features remain the same. - If you rely on skill card-based documentation or descriptions, please update your references accordingly.",
      "href": "https://clawhub.ai/cloudcode-hans/sql-linker",
      "sourceUrl": "https://clawhub.ai/cloudcode-hans/sql-linker",
      "sourceType": "release",
      "confidence": "medium",
      "observedAt": "2026-06-27T07:34:51.507Z",
      "isPublic": true
    }
  ]
}

Record generated Oct 10, 2026.

Sponsored

Ads related to sql-linker and adjacent AI workflows.