Execute SQL queries against project databases with automatic SSH tunnel management.
npx skills add https://github.com/zangxin75/openclaw-skills --skill db-query-zangxin75
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
This Skill simplifies querying project databases, especially those protected by SSH tunnels, by automating the connection and query execution process.
Use the db-query skill to list all configured databases.
High-intent search queries and answers about installing and using this skill.
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.
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.
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.
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.
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.
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.
shreed27Manage SSH, ngrok, and Cloudflare tunnels for local services.
gman-roboticsAnalyze Excel and CSV files with DuckDB SQL queries and export results.
brixtonphamConnect to PostgreSQL databases and execute SQL queries via psql.
alsk1992Manage secure remote access and tunneling for local services via SSH, ngrok, and Cloudflare Tunnels.
