skills.rest
AmirEmad11
AmirEmad11COMMUNITY
Explore all skills by this author →
GitHub

query-integration-data

Query and modify data in connected integrations and data warehouses via API calls.

Updated Apr 20, 2026
Search Tags:#data query#api integration#linear#bigquery#snowflake#csv export#write operations
One-click install
npx skills add https://github.com/AmirEmad11/instabot --skill query-integration-data-amiremad11
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: query-integration-data
Source: https://github.com/AmirEmad11/instabot/tree/main/.local/skills/query-integration-data
Command: npx skills add https://github.com/AmirEmad11/instabot --skill query-integration-data-amiremad11

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @linear/sdk.

What problem does it solve? Answering questions or performing operations that require live data from external services (Linear, GitHub, HubSpot, Slack, Google, Databricks, Snowflake, BigQuery) normally requires manual API setup and scripting. This Skill retrieves existing connection credentials and runs read or write operations directly in the code execution sandbox. ## Core Features & Use Cases - Read operations: Query issues, contacts, messages, or warehouse tables to answer questions in chat, with results printed or exported to CSV/JSON. - Write operations: Create, update, or delete records such as Linear tickets, HubSpot contacts, or Slack messages, with clarifying questions for required IDs and fields. - Warehouse exploration: Run parallel subagents to explore large BigQuery, Snowflake, or Databricks schemas (15+ tables) before writing the final SQL query. - Use Case: A user asks "How many Linear issues were created this week?" — the Skill fetches credentials via listConnections, queries the Linear API, and prints the count. ## Quick Start Ask a question about your connected service data, such as "List my open GitHub issues and export them to a CSV file."

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 Linear or GitHub data from a connected integration?▼

Call listConnections with the connector name to retrieve stored credentials, then construct the service's SDK client and run your query in the code execution sandbox. Results are printed with console.log or exported to CSV files.

How do I create or update records in an external service via API?▼

Fetch valid options first (users, projects, states) with a read query, ask clarifying questions when references are ambiguous, then call the SDK's create, update, or delete methods. Always browse the integration's public documentation link before write operations.

What happens if no connection exists for the service I want to query?▼

listConnections returns an empty array when no connection is configured. In that case, use searchIntegrations, proposeIntegration, and addIntegration to set up a new connection before executing queries.

Can I query BigQuery, Snowflake, or Databricks with this approach?▼

Yes, warehouse connections are queried with executeSql using the appropriate target and SQL dialect. For schemas with 15 or more tables, launch 2-4 parallel subagents to explore table groups before writing the final query.

When should I not use this Skill for data questions?▼

Do not use it when the user wants to build a dashboard or visualization interface — that belongs to the data-visualization skill. It is also not for adding integrations to an app, production database operations, or checking deployment logs.

Related Skills

Explore More Data & Analytics Skills→
ItsJupiter000ItsJupiter000

query-integration-data

Query and modify data across connected integrations and data warehouses.

Community
Advanced
SalesTeamToolboxSalesTeamToolbox

data-analysis

Guide data analysis from CSV/JSON loading through cleaning, exploration, visualization, and export.

Community
Intermediate
microsoftmicrosoft
483

add-connector

Integrate Power Platform connectors into Power Apps code via CLI commands.

Official
Intermediate
PayRamPayRam
155

payram-analytics

Query PayRam analytics via MCP tools for payments, user growth, and transaction summaries.

Official
Intermediate