skills.rest
sundy-li
sundy-liCOMMUNITY
Explore all skills by this author →
Website𝕏@sundyli1GitHub

arrow-cli

Execute Flight SQL queries against a remote server with selectable output formats.

13|3|Updated Mar 25, 2023
Search Tags:#cli#repl#data export#query execution#schema inspection#flight sql#sql client
One-click install
npx skills add https://github.com/sundy-li/arrow_cli --skill arrow-cli
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: arrow-cli
Source: https://github.com/sundy-li/arrow_cli/tree/main
Command: npx skills add https://github.com/sundy-li/arrow_cli --skill arrow-cli

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Use this Skill to quickly connect to a Flight SQL server and execute SQL, so you can avoid manual setup and repetitive client work when exploring data or validating queries.

Core Features & Use Cases

  • Connect and authenticate to Flight SQL: Provide host, port, username, and password, then run queries against the remote service.
  • Execute queries in multiple modes: Run a single statement and exit, pipe SQL via standard input, or use an interactive REPL workflow.
  • Control output and visibility: Choose table or delimited/structured outputs (json, csv, tsv, psv) and optionally print the decoded result schema for debugging and planning.

Quick Start

Run arrow_cli with your server URL, credentials, and a SQL statement using the --command option to execute and immediately view results.

Frequently Asked Questions about arrow-cli

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

FAQPage Schema
How do I run Flight SQL queries from the terminal?▼

You can run Flight SQL queries from the terminal by providing the server host, port, and credentials to execute statements and view results directly in your command line.

Can I pipe SQL via standard input for query execution?▼

Yes, you can pipe SQL statements via standard input to streamline data export workflows, alongside running single statements or using an interactive REPL session.

What output formats are available when using a Flight SQL client?▼

Available output formats for Flight SQL query results include table, json, csv, tsv, and psv, allowing flexible data export and integration into various pipelines.

How do I inspect the schema of Flight SQL query results?▼

You can inspect the decoded result schema by enabling an optional schema printing flag during query execution, which aids in debugging and data structure planning.

Do I need specific credentials to connect to a Flight SQL server?▼

Yes, connecting to a Flight SQL server requires a valid host, port, username, and password to authenticate and execute queries against the remote service.

Related Skills

Explore More Data & Analytics Skills→
theslashdojotheslashdojo

remote-forward

Expose local services through a remote host using reverse SSH tunneling.

Official
Intermediate
antgroupantgroup
16

csv-pipeline

Process, transform, and analyze CSV, TSV, and JSON tabular data.

Official
Advanced
sahiixxsahiixx
2

query-writing

Generate and execute SQL queries for database data retrieval.

Community
Intermediate
olasunkanmi-SEolasunkanmi-SE
139

postgres

Automate PostgreSQL database interactions via the psql CLI.

Community
Intermediate