Azure Data Studio

A data processing and analysis toolkit for querying, importing, exporting, transforming, and validating data. Provides a lightweight CLI interface for common data operations with persistent local storage.

Commands

Data Storage

• - Data directory: ~/.local/share/azuredatastudio/ (override with AZUREDATASTUDIO_DIR env variable)
• Data log: $DATA_DIR/data.log — primary data storage file for records
• History log: $DATA_DIR/history.log — tracks all command executions with timestamps

Schema

The default data schema uses the following fields:

Requirements

• - Bash 4.0+
• Standard Unix utilities (wc, head, cat, date)
• No API keys or external services needed
• No database server required — uses flat file storage
• Works on Linux and macOS

When to Use

1. 1. Data querying — When you need to run quick queries against your local data store without spinning up a full database
2. File import/export — When you need to import data files into the local store or export records for use in other tools
3. Data validation — When you want to verify your data conforms to the expected schema before processing
4. Data transformation — When you need to convert data between formats (e.g., restructuring fields)
5. Quick statistics — When you want to see basic metrics like total record count or preview sample data at a glance

Examples

CODEBLOCK0

Output

All command results are printed to stdout. You can redirect output with standard shell operators:

CODEBLOCK1

Configuration

Set the AZUREDATASTUDIO_DIR environment variable to change the data directory:

CODEBLOCK2

Default location: ~/.local/share/azuredatastudio/