agentCLAWHUBUnverified

Database Helper Pro

数据库助�?- SQL查询构建�?Schema管理/数据导入导出,支持SQLite/MySQL/PostgreSQL,含ORM模板 Skill: Database Helper Pro Owner: 534422530 Summary: 数据库助�?- SQL查询构建�?Schema管理/数据导入导出,支持SQLite/MySQL/PostgreSQL,含ORM模板 Tags: database:2.0.0, development:1.0.0, latest:2.0.0, pro:2.0.0, query:2.0.0, schema:2.0.0, sql:2.0.0 Version history: v2.0.0 | 2026-05-29T23:31:26.027Z | auto Version 2.0.0 of laosi-database-helper introduces premium status and metadata changes. - Added hub.json file for enhanced configuration supp

OpenClaw

Rank

62

Safety

84

Downloads

1.1k

Updated

Oct 11, 2026

Version

2.0.0

Source

CLAWHUB

About

What it does, and when to use it.

Capability contract not published. No trust telemetry is available yet. 1.1K downloads reported by the source. Last updated 10/11/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 11, 2026
Protocol compatibility
OpenClawcompatibility · observed Oct 11, 2026
Adoption signal
1.1K downloadsadoption · observed Oct 11, 2026
Latest release
2.0.0release · observed May 29, 2026
Handshake status
UNKNOWNsecurity

Install and run

Setup complexity: low.

clawhub skill install s170k9770tgh0506hw0dwtb6pd83kwyq:laosi-database-helper
  1. Setup complexity is LOW. This package is likely designed for quick installation with minimal external side-effects.
  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-534422530-laosi-database-helper/snapshot"

Documentation

CLAWHUB

23,025 characters of source documentation, loaded on request.

Extracted files

4 files captured from the source.

SKILL.md

---
badge: premium
name: database-helper
version: 2.0.0
description: 数据库助�?- SQL查询构建�?Schema管理/数据导入导出,支持SQLite/MySQL/PostgreSQL,含ORM模板
tags: [database, sql, query, schema, development, data]
author: laosi
source: original
---

# Database Helper - 数据库助�?
> 激活词: 数据�?/ SQL / database / 查询

## 功能

- SQL查询构建器(SELECT/INSERT/UPDATE/DELETE�?- Schema管理(创�?修改表)
- 数据导入/导出(CSV↔SQL�?- 连接池管�?- ORM模板生成

## Python 实现

```python
import os, json, sqlite3
from datetime import datetime
from typing import List, Dict, Optional, Any

class SQLBuilder:
    """SQL查询构建�?""
    
    def __init__(self, table: str = ""):
        self.table = table
        self._query = ""
        self._params = []
    
    def select(self, *columns) -> 'SQLBuilder':
        cols = ", ".join(columns) if columns else "*"
        self._query = f"SELECT {cols} FROM {self.table}"
        return self
    
    def where(self, condition: str, *params) -> 'SQLBuilder':
        self._query += f" WHERE {condition}"
        self._params.extend(params)
        return self
    
    def order_by(self, column: str, desc: bool = False) -> 'SQLBuilder':
        direction = "DESC" if desc else "ASC"
        self._query += f" ORDER BY {column} {direction}"
        return self
    
    def limit(self, n: int) -> 'SQLBuilder':
        self._query += f" LIMIT {n}"
        return self
    
    def join(self, table: str, on: str) -> 'SQLBuilder':
        self._query += f" JOIN {table} ON {on}"
        return self
    
    def insert(self, data: dict) -> 'SQLBuilder':
        cols = ", ".join(data.keys())
        placeholders = ", ".join(["?"] * len(data))
        self._query = f"INSERT INTO {self.table} ({cols}) VALUES ({placeholders})"
        self._params = list(data.values())
        return self
    
    def update(self, data: dict) -> 'SQLBuilder':
        set_clause = ", ".join(f"{k} = ?" for k in data.keys())
        self._query = f"UPDATE {self.table} SET {set_clause}"
        self._params = list(data.values())
        return self
    
    def delete(self) -> 'SQLBuilder':
        self._query = f"DELETE FROM {self.table}"
        return self
    
    def build(self) -> tuple:
        return self._query, self._params

class DatabaseHelper:
    def __init__(self, db_path: str = None):
        self.db_path = db_path or ":memory:"
        self.conn: Optional[sqlite3.Connection] = None
    
    def connect(self):
        self.conn = sqlite3.connect(self.db_path)
        self.conn.row_factory = sqlite3.Row
    
    def close(self):
        if self.conn:
            self.conn.close()
    
    def execute(self, query: str, params: tuple = ()) -> List[dict]:
        """执行查询并返回结�?""
        if not self.conn:
            self.connect()
        cursor = self.conn.execute(query, params)
        if query.strip().upper().startswith("SELECT"):
            return [dict(row) for row in cursor.fetchall()]
        else:
            self.conn.commit()
            return [{"affected": cursor.rowcount}]
    
    def create_table(se

_meta.json

{
  "ownerId": "kn71pk44ca87scz3pstt90r66n80xhaa",
  "slug": "laosi-database-helper",
  "version": "2.0.0",
  "publishedAt": 1780097486027
}

skill-card.md

## Description:

Database Helper Pro provides SQL query-building guidance, SQLite helper code, schema inspection, CSV import/export examples, and ORM template generation for database workflows.

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

## Publisher:

[534422530](https://clawhub.ai/user/534422530)

### License/Terms of Use:

MIT-0

## Use Case:

Developers and data practitioners use this skill to prototype local database workflows, compose SQL snippets, inspect schemas, and generate starter code for CSV import/export and ORM models.

### Deployment Geography for Use:

Global

## Known Risks and Mitigations:

Risk: Database write, delete, and schema-change operations could alter or remove production data.

Mitigation: Review generated operations before execution, require explicit confirmation for writes and deletes, and test against backups or disposable databases first.

Risk: Unsafe query-building patterns can expose databases to malformed SQL or injection when identifiers or raw conditions come from untrusted input.

Mitigation: Validate table and column identifiers, parameterize values, and restrict raw SQL fragments to trusted callers.

Risk: The provided implementation is SQLite-focused even though the skill text mentions MySQL and PostgreSQL support.

Mitigation: Confirm database-driver support and dialect differences before using generated code with MySQL or PostgreSQL.

## Reference(s):

- [ClawHub skill page](https://clawhub.ai/534422530/skills/laosi-database-helper)
- [Publisher profile](https://clawhub.ai/user/534422530)

## Skill Output:

**Output Type(s):** [Text, Markdown, Code, Configuration, Guidance]

**Output Format:** [Markdown with Python and SQL code blocks]

**Output Parameters:** [1D]

**Other Properties Related to Output:** [May include SQL snippets, SQLite helper code, schema summaries, CSV import/export examples, and ORM templates.]

## Skill Version(s):

2.0.0 (source: evidence release, SKILL.md frontmatter, hub.json)

## 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.

hub.json

{
    "description":  "Premium version with full implementation, examples, and enterprise support",
    "minOpenClawVersion":  "1.2.0",
    "version":  "2.0.0",
    "tags":  [
                 "database",
                 "sql",
                 "query",
                 "schema",
                 "pro"
             ],
    "author":  "laosi",
    "name":  "database-helper",
    "pricing":  {
                    "price":  2900,
                    "model":  "one-time"
                },
    "license":  "MIT",
    "displayName":  "Database Helper Pro"
}
Github ReposUpdated 2d 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/534422530/skills/laosi-database-helper",
      "sourceUrl": "https://clawhub.ai/534422530/skills/laosi-database-helper",
      "sourceType": "profile",
      "confidence": "medium",
      "observedAt": "2026-10-11T13:07:03.807Z",
      "isPublic": true
    },
    {
      "factKey": "protocols",
      "category": "compatibility",
      "label": "Protocol compatibility",
      "value": "OpenClaw",
      "href": "https://www.xpersona.co/api/v1/agents/clawhub-534422530-laosi-database-helper/contract",
      "sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-534422530-laosi-database-helper/contract",
      "sourceType": "contract",
      "confidence": "medium",
      "observedAt": "2026-10-11T13:07:03.807Z",
      "isPublic": true
    },
    {
      "factKey": "traction",
      "category": "adoption",
      "label": "Adoption signal",
      "value": "1.1K downloads",
      "href": "https://clawhub.ai/534422530/laosi-database-helper",
      "sourceUrl": "https://clawhub.ai/534422530/laosi-database-helper",
      "sourceType": "profile",
      "confidence": "medium",
      "observedAt": "2026-10-11T13:07:03.807Z",
      "isPublic": true
    },
    {
      "factKey": "latest_release",
      "category": "release",
      "label": "Latest release",
      "value": "2.0.0",
      "href": "https://clawhub.ai/534422530/laosi-database-helper",
      "sourceUrl": "https://clawhub.ai/534422530/laosi-database-helper",
      "sourceType": "release",
      "confidence": "medium",
      "observedAt": "2026-05-29T23:31:26.027Z",
      "isPublic": true
    },
    {
      "factKey": "handshake_status",
      "category": "security",
      "label": "Handshake status",
      "value": "UNKNOWN",
      "href": "https://www.xpersona.co/api/v1/agents/clawhub-534422530-laosi-database-helper/trust",
      "sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-534422530-laosi-database-helper/trust",
      "sourceType": "trust",
      "confidence": "medium",
      "observedAt": null,
      "isPublic": true
    }
  ],
  "events": [
    {
      "eventType": "release",
      "title": "Release 2.0.0",
      "description": "Version 2.0.0 of laosi-database-helper introduces premium status and metadata changes. - Added `hub.json` file for enhanced configuration support. - Updated `SKILL.md` with `badge: premium` and new version number. - Minor description and heading text adjustments in SKILL.md. - No code or feature changes in functionality.",
      "href": "https://clawhub.ai/534422530/laosi-database-helper",
      "sourceUrl": "https://clawhub.ai/534422530/laosi-database-helper",
      "sourceType": "release",
      "confidence": "medium",
      "observedAt": "2026-05-29T23:31:26.027Z",
      "isPublic": true
    }
  ]
}

Record generated Oct 11, 2026.

Sponsored

Ads related to Database Helper Pro and adjacent AI workflows.