skills.rest
Darshit-Vaghani
Darshit-VaghaniCOMMUNITY
Explore all skills by this author →
GitHub

query-integration-data

Query and update data across connected integrations and data warehouses.

Updated Aug 27, 2026
Search Tags:#workflow automation#integration#linear#data export#bigquery#crud operations#api querying
One-click install
npx skills add https://github.com/Darshit-Vaghani/swasau_website --skill query-integration-data-darshit-vaghani
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: query-integration-data
Source: https://github.com/Darshit-Vaghani/swasau_website/tree/main/.local/skills/query-integration-data
Command: npx skills add https://github.com/Darshit-Vaghani/swasau_website --skill query-integration-data-darshit-vaghani

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes the friction of manually looking up and updating data across third-party tools by letting you query or write to connected services and data warehouses on demand.

Core Features & Use Cases

  • Read data instantly: Query counts, lists, and exported datasets from integrations like Linear, GitHub, HubSpot, Slack, Google services, and supported warehouses such as BigQuery, Snowflake, and Databricks.
  • Write operations when needed: Create, update, delete, or modify records in the connected system using the authenticated connection.
  • Ad-hoc analysis and exports: Produce direct answers for chat questions or generate CSV/JSON outputs for later use.
  • Connection lifecycle handling: Uses existing credentials via listConnections(), and if missing, follows a search and setup flow using integration tooling.

Quick Start

Use query-integration-data to query Linear for the number of issues created this week and return the result.

Frequently Asked Questions about query-integration-data

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

FAQPage Schema
How do I query data from connected integrations like Linear or BigQuery?▼

To query connected integrations like Linear or BigQuery, this Skill retrieves credentials via listConnections() in the code_execution sandbox, then executes read-heavy investigations to pull counts, lists, or exported datasets directly from those services.

Can I create, update, or delete records in third-party tools through API querying?▼

Yes, API querying supports write workflows to create, update, or delete records in connected systems like Linear, GitHub, and Slack using authenticated connections established through the listConnections() fallback setup flow.

What is the best way to export ad-hoc analysis results from data warehouses like Snowflake or Databricks?▼

The best way to export ad-hoc analysis from warehouses like Snowflake or Databricks is querying the connected integration and returning the output directly as structured CSV or JSON files for later use.

Does this approach handle connection setup when no existing credentials are found?▼

Yes, connection setup is handled automatically. When listConnections() returns no existing credentials, the workflow falls back to integration tooling to guide you through a search and setup flow to establish the required connection.

What are the limitations of modifying records across multiple connected integrations?▼

A key limitation is dependency on authenticated connections; if no connections exist, write workflows pause for setup. Modifications are ad-hoc operational changes scoped to the connected system's API limits rather than bulk database transactions.

Related Skills

Explore More Software Engineering Skills→
dong-frankdong-frank
1

lark-authorize

Configure Lark credentials, authenticate accounts, and verify authorization status.

Community
Basic
sellersessionssellersessions

dashboard-auto-generation-client

Generate standalone HTML dashboards from CSV, Excel, JSON, or TSV files.

Community
Advanced
PixoraftPixoraft

query-integration-data

Query and modify data across connected integrations and data warehouses.

Community
Advanced
timequitytimequity
6

warehouse-optimization

Optimize data warehouse queries and storage across Snowflake, BigQuery, and Redshift.

Official
Intermediate