skills.rest
This-HW
This-HWCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

db-query

Execute SQL queries against PostgreSQL MCP through an SSH-tunneled connection.

Updated Aug 23, 2026
Search Tags:#database#postgresql#queries#data-analysis#query-optimization#ssh-tunnel
One-click install
npx skills add https://github.com/This-HW/hantu_quant --skill db-query-this-hw
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-query
Source: https://github.com/This-HW/hantu_quant/tree/main/.claude/skills/db-query
Command: npx skills add https://github.com/This-HW/hantu_quant --skill db-query-this-hw

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL MCP queries often require secure tunnel access, structured query workflows, and reliable analysis capabilities, which can be tedious to set up manually.

Core Features & Use Cases

  • SSH-tunneled PostgreSQL access: Establish and maintain a secure tunnel to run queries against the MCP.
  • Query execution & analysis: Run ad-hoc SQL, explain plans, and analyze results.
  • Schema discovery & optimization: Inspect schemas and identify performance improvements.

Quick Start

Connect to the PostgreSQL MCP tunnel and run your first query.

Frequently Asked Questions about db-query

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

FAQPage Schema
How do I run PostgreSQL queries through an SSH tunnel for remote data analysis?▼

You can run PostgreSQL queries through an SSH tunnel by establishing a secure connection to the MCP, then executing ad-hoc SQL statements for analysis and schema exploration. This approach provides reliable and repeatable query workflows across local and remote environments.

What's the best way to explore a PostgreSQL schema and optimize query performance?▼

To explore a PostgreSQL schema and optimize query performance, connect via an SSH-tunneled MCP access point to inspect schemas, run ad-hoc SQL queries, and analyze explain plans to identify performance improvements.

Do I need SQL knowledge to use PostgreSQL MCP for query execution and analysis?▼

Yes, you need SQL knowledge to run, explain, and optimize queries against the PostgreSQL MCP. The Skill targets data analysts and software engineers who require reliable database query workflows.

Can I use this approach for both local and remote PostgreSQL database environments?▼

Yes, you can use SSH-tunneled PostgreSQL MCP access for both local and remote database environments. It is designed to provide reliable, repeatable query workflows regardless of your environment setup.

Why does executing PostgreSQL MCP queries manually become tedious?▼

Executing PostgreSQL MCP queries manually is tedious because it requires secure SSH tunnel access setup, structured query workflows, and reliable analysis capabilities, which are complex to configure repeatedly by hand.

What is the process for setting up secure PostgreSQL MCP access?▼

Setting up secure PostgreSQL MCP access involves establishing and maintaining an SSH tunnel to the database. Once the tunnel is active, you can execute queries, explain plans, and analyze results safely.

Related Skills

Explore More Data & Analytics Skills→
zangxin75zangxin75

db-query

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

Community
Intermediate
Datus-aiDatus-ai
1.5k

report-generator

Generate JSON, CSV, or markdown reports from SQL query results.

Official
Basic
codeApe-7codeApe-7
17

sql-pro

Analyze SQL execution plans and suggest indexing strategies.

Community
Advanced
george11642george11642
2

db-supabase

Execute SQL, apply migrations, and deploy edge functions via Supabase MCP tools.

Community
Intermediate