skills.rest
cuemath
cuemathOFFICIAL
Explore all skills by this author →
Website𝕏@CuemathGitHub

db-query

Execute read-only SQL queries on Cuemath analytics replicas via SSH tunnel.

Updated Aug 23, 2026
Search Tags:#analytics#database#sql#query#ssh#rds
One-click install
npx skills add https://github.com/cuemath/dotclaude --skill db-query-cuemath
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-query
Source: https://github.com/cuemath/dotclaude/tree/main/skills/db-query
Command: npx skills add https://github.com/cuemath/dotclaude --skill db-query-cuemath

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill allows users to securely connect to Cuemath's analytics replica databases and execute read-only SQL queries, retrieving crucial data without direct database access.

Core Features & Use Cases

  • Secure SSH Tunneling: Establishes an SSH tunnel to a specified analytics replica for secure data access.
  • SQL Query Execution: Runs provided SQL queries against the target database.
  • Service-to-Cluster Mapping: Automatically determines the correct database cluster and hostname based on the service name.
  • Use Case: A product manager needs to understand user engagement for a specific feature. They can use this skill to query the relevant database table and get the exact metrics needed.

Quick Start

Connect to the 'auth' service database and run the query 'SELECT COUNT(*) FROM users WHERE created_at > NOW() - INTERVAL '1 day';'.

Frequently Asked Questions about db-query

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

FAQPage Schema
How do I run SQL queries on an analytics replica database via SSH?▼

You can run SQL queries on an analytics replica database via SSH by using this Skill to establish a secure SSH tunnel and execute read-only SQL statements, retrieving data without needing direct database credentials.

What is the best way to securely retrieve ad-hoc user data from production replicas?▼

The best way to securely retrieve ad-hoc user data from production replicas is to use this Skill, which connects through an SSH tunnel to execute read-only queries, ensuring production databases remain protected while you extract operational statistics.

Can I query specific service databases like auth and orders without knowing the cluster hostname?▼

Yes, you can query specific service databases like auth and orders without knowing the cluster hostname, because this Skill automatically determines the correct database cluster and hostname based on the provided service name.

Do I need direct database credentials to execute read-only SQL queries?▼

No, you do not need direct database credentials to execute read-only SQL queries, because this Skill satisfies secure data retrieval requirements by connecting to the analytics replica databases via an SSH tunnel instead of using direct access.

What are the limitations of using an SSH tunnel for database queries?▼

A key limitation of using an SSH tunnel for database queries is that access is restricted to read-only SQL statements, meaning you cannot perform write operations, updates, or modify data within the analytics replica databases.

Related Skills

Explore More Data & Analytics Skills→
zangxin75zangxin75

db-query

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

Community
Intermediate
apconwapconw
2.2k

query-writing

Write and execute SQL queries for structured data insights.

Community
Basic
Datus-aiDatus-ai
1.5k

report-generator

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

Official
Basic
weiflycc-cmdweiflycc-cmd

powerbi-consumption-cli

Execute DAX queries against Microsoft Fabric Power BI semantic models for metadata discovery and data retrieval.

Community
Intermediate