Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Tencent SkillHub ยท Developer Tools
MYSQL QUERY
Query project databases with automatic SSH tunnel management. Use when you need to execute SQL queries against configured databases, especially those accessible only via SSH tunnels. Automatically manages SSH connection lifecycle (establishes tunnel before query, closes after). Supports multiple databases distinguished by description/name from config file.
skill openclawclawhub Free
Query project databases with automatic SSH tunnel management. Use when you need to execute SQL queries against configured databases, especially those accessible only via SSH tunnels. Automatically manages SSH connection lifecycle (establishes tunnel before query, closes after). Supports multiple databases distinguished by description/name from config file.
โฌ 0 downloads โ
0 stars Unverified but indexed
Install for OpenClaw
Quick setup
- Download the package from Yavira.
- Extract the archive and review SKILL.md first.
- Import or place the package into your OpenClaw setup.
Package facts
- Download mode
- Yavira redirect
- Package format
- ZIP package
- Source platform
- Tencent SkillHub
- What's included
- SKILL.md, scripts/INSTALL.md, scripts/db_query.py, scripts/config.example.json
Validation
- Use the Yavira download entry.
- Review SKILL.md after the package is downloaded.
- Confirm the extracted package contains the expected setup assets.
Install with your agent
Agent handoff
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
- Download the package from Yavira.
- Extract it into a folder your agent can access.
- Paste one of the prompts below and point your agent at the extracted folder.
New install
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.
Upgrade existing
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.
Trust & source
Release facts
- Source
- Tencent SkillHub
- Verification
- Indexed source record
- Version
- 1.0.1
Provenance
- Publisher
- zenixp
- Source page
- View original listing
- Canonical URL
- Open canonical page
Documentation
Overview
Query databases through a centralized configuration file with automatic SSH tunnel management. Handles connection details, SSH tunnel setup/teardown, and query execution.
Security
Passwords are never exposed in process lists. The skill uses environment variables for credentials: MYSQL_PWD for database passwords (passed to mysql client) SSHPASS for SSH tunnel passwords (passed to sshpass) Recommended: Store credentials in environment variables instead of the config file for better security.
Setup
Create config file at ~/.config/clawdbot/db-config.json: mkdir -p ~/.config/clawdbot # Copy example config and edit cp /usr/lib/node_modules/clawdbot/skills/db-query/scripts/config.example.json ~/.config/clawdbot/db-config.json Add database entries with these fields: name: Description used to find the database (required) host: Database host (required) port: Database port (default: 3306) database: Database name (required) user: Database user (required) password: Database password (optional, can use env var) ssh_tunnel: Optional SSH tunnel configuration SSH tunnel configuration (if needed): enabled: true/false ssh_host: Remote SSH host ssh_user: SSH username ssh_port: SSH port (default: 22) local_port: Local port to forward (e.g., 3307) remote_host: Remote database host behind SSH (default: localhost) remote_port: Remote database port (default: 3306)
Environment Variables (Recommended)
Instead of storing passwords in the config file, use environment variables: # Format: DB_PASSWORD_<DATABASE_NAME> (spaces replaced with underscores, uppercase) export DB_PASSWORD_PRODUCTION_USER_DB="your_db_password" # Format: SSH_PASSWORD_<DATABASE_NAME> for SSH tunnel password export SSH_PASSWORD_PRODUCTION_USER_DB="your_ssh_password"
Example Config
{ "databases": [ { "name": "Production User DB", "host": "localhost", "port": 3306, "database": "user_db", "user": "db_user", "password": "", "ssh_tunnel": { "enabled": true, "ssh_host": "prod.example.com", "ssh_user": "deploy", "local_port": 3307 } } ] } Set environment variables (recommended): export DB_PASSWORD_PRODUCTION_USER_DB="your_db_password" export SSH_PASSWORD_PRODUCTION_USER_DB="your_ssh_password"
List Databases
python3 /usr/lib/node_modules/clawdbot/skills/db-query/scripts/db_query.py --list
Query a Database
python3 /usr/lib/node_modules/clawdbot/skills/db-query/scripts/db_query.py \ --database "Production User DB" \ --query "SELECT * FROM users LIMIT 10" The script will: Find database by matching description in config Start SSH tunnel (if configured) Execute query Automatically close SSH tunnel (important for cleanup)
With Custom Config Path
python3 /usr/lib/node_modules/clawdbot/skills/db-query/scripts/db_query.py \ --config /path/to/custom-config.json \ --database "test" \ --query "SHOW TABLES"
Requirements
MySQL client: apt install mysql-client or equivalent SSH client: usually pre-installed on Linux/Mac Python 3.6+
Notes
SSH tunnels are automatically closed after query execution Use --list to see all configured databases and their descriptions Database search is case-insensitive partial match on name field Local ports for SSH tunnels should be unique per database
Category context
Code helpers, APIs, CLIs, browser automation, testing, and developer operations.
Source: Tencent SkillHub
Largest current source with strong distribution and engagement signals.
Package contents
Included in package
2 Docs1 Scripts1 Config
- SKILL.md
- scripts/INSTALL.md
- scripts/db_query.py
- scripts/config.example.json