db-queryQuery 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.
Install via ClawdBot CLI:
clawdbot install zenixp/db-queryQuery databases through a centralized configuration file with automatic SSH tunnel management. Handles connection details, SSH tunnel setup/teardown, and query execution.
~/.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.jsonname: 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 (required)ssh_tunnel: Optional SSH tunnel configurationenabled: true/falsessh_host: Remote SSH hostssh_user: SSH usernamessh_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){
"databases": [
{
"name": "ηδΊ§η¨ζ·εΊ",
"host": "localhost",
"port": 3306,
"database": "user_db",
"user": "db_user",
"password": "secret",
"ssh_tunnel": {
"enabled": true,
"ssh_host": "prod.example.com",
"ssh_user": "deploy",
"local_port": 3307
}
}
]
}python3 /usr/lib/node_modules/clawdbot/skills/db-query/scripts/db_query.py --listpython3 /usr/lib/node_modules/clawdbot/skills/db-query/scripts/db_query.py \
--database "ηδΊ§η¨ζ·εΊ" \
--query "SELECT * FROM users LIMIT 10"The script will:
python3 /usr/lib/node_modules/clawdbot/skills/db-query/scripts/db_query.py \
--config /path/to/custom-config.json \
--database "test" \
--query "SHOW TABLES"apt install mysql-client or equivalent--list to see all configured databases and their descriptionsname fieldGenerated Mar 1, 2026
An e-commerce platform uses this skill to query customer databases hosted on remote servers via SSH tunnels, enabling secure access to purchase history and user profiles for analytics. It automates tunnel management, reducing manual setup for data teams extracting insights from production databases.
A healthcare provider employs this skill to securely query patient databases behind SSH-protected servers, ensuring compliance with data privacy regulations. It facilitates automated audits by allowing staff to run SQL queries on medical records without exposing sensitive connections.
A fintech company uses this skill to monitor transaction databases accessible only through SSH tunnels, enabling real-time querying for fraud detection and reporting. The automatic tunnel lifecycle management ensures secure and efficient access to financial data across distributed systems.
A SaaS provider leverages this skill to query user activity databases hosted on cloud servers via SSH, tracking application performance and usage metrics. It simplifies database access for DevOps teams, supporting automated reporting and troubleshooting without manual SSH configurations.
A manufacturing firm applies this skill to query inventory and logistics databases behind corporate firewalls using SSH tunnels, enabling data-driven decisions for supply chain management. It automates secure database connections, allowing analysts to extract real-time data for optimization efforts.
Offer this skill as part of a subscription service for businesses needing secure database querying, charging monthly fees based on usage tiers or number of databases managed. Revenue is generated through recurring payments, with premium features like advanced analytics integration.
Provide consulting services to integrate this skill into client workflows, customizing configurations and offering training for specific industries. Revenue comes from one-time project fees and ongoing support contracts, targeting enterprises with complex database environments.
Distribute this skill as a freemium tool where basic querying is free, but advanced features like multi-database management or enhanced security options require a paid license. Revenue is generated through upselling to premium versions and enterprise licenses.
π¬ Integration Tip
Ensure SSH keys are properly configured for automated tunnel access, and test queries in a staging environment before production use to avoid disruptions.
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Manage Things 3 via the `things` CLI on macOS (add/update projects+todos via URL scheme; read/search/list from the local Things database). Use when a user asks Clawdbot to add a task to Things, list inbox/today/upcoming, search tasks, or inspect projects/areas/tags.
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Query, design, migrate, and optimize SQL databases. Use when working with SQLite, PostgreSQL, or MySQL β schema design, writing queries, creating migrations, indexing, backup/restore, and debugging slow queries. No ORMs required.