Demo ModeExplore all 8 database types with sample data • PostgreSQL, MySQL, SQLite, BigQuery, ClickHouse, DuckDB, Snowflake, Databricks
ARESA Studio

ARESA Studio

v0.2.0

Powered by ARESA CLI

ARESA Studio/Help & Tutorial

ARESA CLI Reference

Query any database from your terminal. Fast, simple, and powerful.

Quick Start

1. Add a connection:

aresa config add postgres mydb --uri "postgresql://user:pass@host/db"

2. Run a query:

aresa query mydb "SELECT * FROM users LIMIT 10"

Database Commands

BigQuery

Google BigQuery data warehouse

Add a BigQuery connection:

aresa config add bigquery prod --project my-gcp-project

Uses Application Default Credentials (gcloud auth login)

Run a query:

aresa query prod "SELECT * FROM `dataset.table` LIMIT 10"

Query with output format:

aresa query prod "SELECT * FROM users" --format json

PostgreSQL

The world's most advanced open source database

Add a PostgreSQL connection:

aresa config add postgres mydb --uri "postgresql://user:password@localhost:5432/database"

Run a query:

aresa query mydb "SELECT * FROM users WHERE active = true"

Export results to CSV:

aresa query mydb "SELECT * FROM orders" --format csv > orders.csv

MySQL

Popular open-source relational database

Add a MySQL connection:

aresa config add mysql mydb --uri "mysql://user:password@localhost:3306/database"

Run a query:

aresa query mydb "SELECT COUNT(*) FROM products"

ClickHouse

Fast open-source OLAP database

Add a ClickHouse connection:

aresa config add clickhouse analytics --host localhost --port 8123

Run a query:

aresa query analytics "SELECT count() FROM events WHERE date > today() - 7"

SQLite

Lightweight embedded database

Add a SQLite connection:

aresa config add sqlite local --uri "/path/to/database.db"

Run a query:

aresa query local "SELECT * FROM sqlite_master WHERE type='table'"

Snowflake

Cloud data warehouse platform

Add a Snowflake connection:

aresa config add snowflake prod --account xy12345.us-east-1 --warehouse COMPUTE_WH --user myuser

Password stored securely in system keychain

Run a query:

aresa query prod "SELECT * FROM MY_DB.PUBLIC.USERS LIMIT 10"

List schemas:

aresa schema prod

Databricks

Unified analytics and AI platform

Add a Databricks connection:

aresa config add databricks lakehouse --host adb-123.azuredatabricks.net --warehouse abc123 --token dapi...

Requires SQL Warehouse ID and Personal Access Token

Run a query:

aresa query lakehouse "SELECT * FROM main.default.customers LIMIT 10"

With Unity Catalog:

aresa query lakehouse "SELECT * FROM catalog.schema.table"

Configuration Commands

Manage Connections

Add, remove, and list database connections

List all connections:

aresa config list

Test a connection:

aresa config test mydb

Remove a connection:

aresa config remove mydb

Check all connections:

aresa config check

Output Formats

ARESA supports multiple output formats for query results:

Table (default)

aresa query mydb "SELECT * FROM users" --format table

JSON

aresa query mydb "SELECT * FROM users" --format json

CSV

aresa query mydb "SELECT * FROM users" --format csv

Markdown

aresa query mydb "SELECT * FROM users" --format markdown

💡 Pro Tips

  • •Use --limit N to restrict result rows
  • •Pipe to jq for JSON processing: aresa query mydb "..." --format json | jq '.[]'
  • •Store sensitive URIs securely - ARESA uses your system's keychain
  • •Config file location: ~/.config/aresa/config.toml

Need more help?

Back to DashboardTry Query Editor