db-query

Name: db-query
Availability: InStock
Author: zangxin75

Execute SQL queries against project databases with automatic SSH tunnel management.

Updated Mar 1, 2026

Search Tags:#automation #database #sql #query #tunnel #ssh

Ready to run

npx skills add https://github.com/zangxin75/openclaw-skills --skill db-query-zangxin75

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: db-query
Source: https://github.com/zangxin75/openclaw-skills/tree/main/db-query
Command: npx skills add https://github.com/zangxin75/openclaw-skills --skill db-query-zangxin75

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies querying project databases, especially those protected by SSH tunnels, by automating the connection and query execution process.

Core Features & Use Cases

Automated SSH Tunnel Management: Establishes and tears down SSH tunnels automatically before and after query execution.
Centralized Configuration: Manages multiple database connections and their SSH tunnel settings in a single JSON file.
Use Case: Connect to a production database that is only accessible via an SSH jump host, execute a complex SQL query, and retrieve the results without manual tunnel setup.

Quick Start

Use the db-query skill to list all configured databases.

Frequently Asked Questions about db-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I query a remote database that requires an SSH tunnel?▼

Querying a remote database via an SSH tunnel is automated by establishing the connection, executing the SQL query, and tearing down the tunnel automatically. This requires a JSON configuration file containing database credentials and SSH parameters.

Can I manage multiple database connections with different SSH tunnel settings?▼

Yes, you can manage multiple database connections with different SSH tunnel settings. The process utilizes a centralized JSON configuration file to store and handle various database credentials and tunnel parameters for each project database.

What is the best way to execute SQL queries against production databases securely?▼

Executing SQL queries securely against production databases is handled by routing traffic through an SSH jump host. The system automates the SSH tunnel lifecycle, ensuring secure access to internal databases without manual setup or exposing direct external access.

Do I need a configuration file to automate SSH tunnel management for database queries?▼

Yes, a JSON configuration file is required to automate SSH tunnel management. This file provides the necessary database credentials and SSH tunnel parameters needed to establish the connection and execute the SQL query successfully.

How does automated SSH tunnel lifecycle management work for database access?▼

Automated SSH tunnel lifecycle management works by creating the tunnel immediately before query execution and tearing it down right after. This ensures secure, temporary access to remote or internal databases without leaving persistent open connections.

Does this tool support connecting to internal databases behind a jump host?▼

Yes, connecting to internal databases behind a jump host is fully supported. By specifying the SSH tunnel parameters in the JSON configuration file, the system securely connects to databases otherwise inaccessible from the local environment.