skills.rest
zerowater-may
zerowater-mayCOMMUNITY
Explore all skills by this author →
GitHub

zipsaja-data-fetch

Fetches Seoul real estate transaction data from PostgreSQL via SSH tunnel and outputs JSON.

Updated Feb 26, 2026
Search Tags:#postgresql#json#data-fetch#real-estate#seoul#ssh-tunnel#zipsaja
One-click install
npx skills add https://github.com/zerowater-may/howzero_threads --skill zipsaja-data-fetch
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: zipsaja-data-fetch
Source: https://github.com/zerowater-may/howzero_threads/tree/main/.claude/skills/zipsaja-data-fetch
Command: npx skills add https://github.com/zerowater-may/howzero_threads --skill zipsaja-data-fetch

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This skill automates fetching and formatting Seoul real estate transaction data by tunneling through SSH to the proptech PostgreSQL database and exporting results as JSON for downstream consumption.

Core Features & Use Cases

  • SSH-tunneled access to hh-worker-2 and the proptech_db to retrieve real_prices and complexes data for Seoul districts.
  • Predefined SQL presets (e.g., leejaemyung-before-after) with parameters such as pivot_date and min_total_units to generate comparable price views.
  • Standalone execution or seamless integration as a branch in the zipsaja pipeline, producing structured JSON for dashboards or analyses.

Quick Start

Run the zipsaja data fetch with default settings to generate the Seoul real prices JSON.

Frequently Asked Questions about zipsaja-data-fetch

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

FAQPage Schema
How do I fetch Seoul real estate transaction data from a PostgreSQL database via SSH?▼

You can fetch Seoul real estate transaction data from PostgreSQL via SSH by establishing an SSH tunnel to the database server, executing predefined SQL presets, and exporting the queried pricing and complex data as structured JSON.

Can I filter Seoul real estate prices for districts with a minimum number of units?▼

Yes, you can filter Seoul real estate prices for specific districts by using the min_total_units parameter within the SQL presets, allowing you to target residential complexes containing 300 or more total units.

How do I compare Seoul real estate prices before and after a specific date?▼

To compare Seoul real estate prices across temporal periods, you can apply the leejaemyung-before-after SQL preset and specify a pivot_date parameter to generate comparable price views in the JSON output.

Do I need an SSH tunnel to extract real_prices data from the zipsaja PostgreSQL pipeline?▼

Yes, an active SSH tunnel to the proptech PostgreSQL database is required to securely extract the real_prices and complexes data, ensuring the data fetch operation can execute the SQL presets and output JSON correctly.

Related Skills

Explore More Data & Analytics Skills→
zangxin75zangxin75

db-query

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

Community
Intermediate
chatdaerichatdaeri
27

ipzitalk-recent-market-trend

Compare trade volume and median prices across real estate districts.

Community
Advanced
huydepzai121huydepzai121
3

postgresql-psql

Execute PostgreSQL psql commands for connections, queries, and administration.

Community
Intermediate
zrt-ai-labzrt-ai-lab
266

smart-query

Query remote databases via natural language to SQL over SSH.

Community
Intermediate