{"id":"a296ae3c-a95e-4208-9a95-da02b4210c2e","slug":"clawhub-534422530-laosi-database-helper","name":"Database Helper Pro","description":"数据库助�?- SQL查询构建�?Schema管理/数据导入导出，支持SQLite/MySQL/PostgreSQL，含ORM模板","canonicalUrl":"https://www.xpersona.co/agent/clawhub-534422530-laosi-database-helper","sourceUrl":"https://clawhub.ai/534422530/laosi-database-helper","homepage":"https://clawhub.ai/534422530/skills/laosi-database-helper","source":"CLAWHUB","vendor":{"slug":"clawhub","label":"Clawhub","url":"https://clawhub.ai/534422530/skills/laosi-database-helper"},"protocols":["OPENCLEW"],"capabilities":[],"trustScore":null,"trustConfidence":"unknown","artifactCount":0,"benchmarkCount":0,"lastRelease":"2.0.0","freshnessAt":"2026-10-11T13:07:03.747Z","freshnessLabel":"Oct 11, 2026","securityReviewed":true,"openapiReady":false,"stats":[{"label":"Trust score","value":"Unknown"},{"label":"Compatibility","value":"OpenClaw"},{"label":"Freshness","value":"Oct 11, 2026"},{"label":"Vendor","value":"Clawhub"},{"label":"Artifacts","value":"0"},{"label":"Benchmarks","value":"0"},{"label":"Last release","value":"2.0.0"}],"factsPreview":[{"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}],"highlights":["1.1K downloads","Trust evidence available"],"agentCard":{"name":"Database Helper Pro","description":"数据库助�?- SQL查询构建�?Schema管理/数据导入导出，支持SQLite/MySQL/PostgreSQL，含ORM模板","source":"CLAWHUB","sourceId":"clawhub:s170k9770tgh0506hw0dwtb6pd83kwyq:laosi-database-helper","homepage":"https://clawhub.ai/534422530/skills/laosi-database-helper","repository":"https://clawhub.ai/534422530/laosi-database-helper","documentation":"https://www.xpersona.co/agent/clawhub-534422530-laosi-database-helper","protocols":["OPENCLEW"],"examples":[{"kind":"example","language":"python","snippet":"import os, json, sqlite3\nfrom datetime import datetime\nfrom typing import List, Dict, Optional, Any\n\nclass SQLBuilder:\n    \"\"\"SQL查询构建�?\"\"\n    \n    def __init__(self, table: str = \"\"):\n        self.table = table\n        self._query = \"\"\n        self._params = []\n    \n    def select(self, *columns) -> 'SQLBuilder':\n        cols = \", \".join(columns) if columns else \"*\"\n        self._query = f\"SELECT {cols} FROM {self.table}\"\n        return self\n    \n    def where(self, condition: str, *params) -> 'SQLBuilder':\n        self._query += f\" WHERE {condition}\"\n        self._params.extend(params)\n        return self\n    \n    def order_by(self, column: str, desc: bool = False) -> 'SQLBuilder':\n        direction = \"DESC\" if desc else \"ASC\"\n        self._query += f\" ORDER BY {column} {direction}\"\n        return self\n    \n    def limit(self, n: int) -> 'SQLBuilder':\n        self._query += f\" LIMIT {n}\"\n        return self\n    \n    def join(self, table: str, on: str) -> 'SQLBuilder':\n        self._query += f\" JOIN {table} ON {on}\"\n        return self\n    \n    def insert(self, data: dict) -> 'SQLBuilder':\n        cols = \", \".join(data.keys())\n        placeholders = \", \".join([\"?\"] * len(data))\n        self._query = f\"INSERT INTO {self.table} ({cols}) VALUES ({placeholders})\"\n        self._params = list(data.values())\n        return self\n    \n    def update(self, data: dict) -> 'SQLBuilder':\n        set_clause = \", \".join(f\"{k} = ?\" for k in data.keys())\n        self._query = f\"UPDATE {self.table} SET {set_clause}\"\n        self._params = list(data.values())\n        return self\n    \n    def delete(self) -> 'SQLBuilder':\n        self._query = f\"DELETE FROM {self.table}\"\n        return self\n    \n    def build(self) -> tuple:\n        return self._query, self._params\n\nclass DatabaseHelper:\n    def __init__(self, db_path: str = None):\n        self.db_path = db_path or \":memory:\"\n        self.conn: Optional[sqlite3.Connection] = None\n    \n    def connect(self):\n        self.conn = sqlite3."},{"kind":"example","language":"sql","snippet":"-- 基础查询\nSELECT * FROM users WHERE age > 30 ORDER BY name LIMIT 10;\n\n-- 聚合\nSELECT city, COUNT(*) as cnt, AVG(age) as avg_age\nFROM users GROUP BY city HAVING cnt > 1;\n\n-- 联表\nSELECT u.name, o.amount\nFROM users u\nJOIN orders o ON u.id = o.user_id\nWHERE o.status = 'completed';\n\n-- 窗口函数\nSELECT name, age,\n       RANK() OVER (ORDER BY age DESC) as rank\nFROM users;"}]}}