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
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- Setup complexity is LOW. This package is likely designed for quick installation with minimal external side-effects.
- 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"
}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!
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
cherry-studio
AI productivity studio with smart chat, autonomous agents, and 300+ assistants.
CopilotKit
The Frontend for Agents & Generative UI. React + Angular
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.
