skills.rest
koya-alt
koya-altCOMMUNITY
Explore all skills by this author →
GitHub

query-integration-data

Query and modify records from connected services and data warehouses.

Updated Apr 1, 2026
Search Tags:#automation#api#integration#sql#query#data-warehouse
One-click install
npx skills add https://github.com/koya-alt/Catalyst --skill query-integration-data-koya-alt
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: query-integration-data
Source: https://github.com/koya-alt/Catalyst/tree/main/local/skills/query-integration-data
Command: npx skills add https://github.com/koya-alt/Catalyst --skill query-integration-data-koya-alt

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Users need to access and modify data stored in external services or data warehouses directly from chat, without building separate dashboards or writing extensive code.

Core Features & Use Cases

  • Retrieve records, counts, or exports from integrations such as Linear, GitHub, HubSpot, Slack, and cloud data warehouses.
  • Create, update, or delete items like tickets, contacts, or database entries through API calls.
  • Run ad‑hoc SQL queries against BigQuery, Snowflake, or Databricks and export results as CSV or JSON.

Quick Start

Ask the assistant to list the number of open Linear issues created this week.

Frequently Asked Questions about query-integration-data

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

FAQPage Schema
How do I run ad-hoc SQL queries against BigQuery or Snowflake from chat?▼

Run ad-hoc SQL queries against BigQuery, Snowflake, or Databricks by leveraging Replit's listConnections API to obtain credentials and execute code in the sandbox. You can instantly retrieve records and export results as CSV or JSON without external scripts.

Can I retrieve and update records from integrations like Linear and HubSpot directly?▼

Yes, you can retrieve, create, update, or delete records from integrations like Linear, GitHub, and HubSpot. This allows you to manage tickets, issues, and contacts directly through API calls without building separate dashboards.

What is the best way to access data warehouse records for automation without external scripts?▼

The best way to access data warehouse records for automation is using the listConnections API to fetch credentials and run code in the sandbox. This approach retrieves or modifies records from BigQuery, Snowflake, and Databricks instantly.

Does this approach require building separate dashboards to export integration data?▼

No, it does not require building separate dashboards. You can directly access and modify data from connected services and data warehouses from chat, exporting query results as CSV or JSON files for reporting and automation.

How do I get credentials to execute SQL against Databricks in a sandbox environment?▼

Leverage Replit's listConnections API to securely obtain the necessary credentials. This allows you to authenticate and execute SQL queries against Databricks directly within the sandbox environment.

Can I export SQL query results from data warehouses as CSV or JSON?▼

Yes, you can export SQL query results from BigQuery, Snowflake, and Databricks as CSV or JSON. This enables immediate data extraction and reporting directly from your chat interface.

Related Skills

Explore More Software Engineering Skills→
Celia-12Celia-12

query-integration-data

Query and modify data in connected integrations and data warehouses.

Community
Advanced
Fl2vioFl2vio
1

Verification & Quality Assurance

Automate code, agent, and task verification with real-time truth scoring.

Community
Advanced
giadaf-booshagiadaf-boosha
10

sql-queries

Guide writing optimized SQL queries across Snowflake, BigQuery, Databricks, PostgreSQL, and Redshift.

Community
Advanced
lucidashlucidash
5

good-morning

Aggregates GitHub, Notion, and Slack activity into a prioritized daily task list and Slack-ready payload.

Community
Intermediate