Claude Code for data analysis
A command line tool that gives you direct natural language access to your databases, csv files, and excel files. You can use it to explore data, write and run queries, and export csv and markdown files to share with others - all directly from your terminal.
Macro Terminal's agentic analytics engine accepts natural language queries and automatically discovers tables, chooses between remote and local processing, and manages memory for large datasets. Users describe what they need in plain English and the agent handles query generation and execution.
Automatic query history feature saves every query result with timestamps and provides built-in pivot tables for reshaping data, enabling full audit trail and easy reuse of previous analyses without re-running queries.
IDE integration feature allows Macro Terminal to work seamlessly within VS Code and Cursor editors with native diff review, automatic context detection from active files, and error detection from installed extensions.
Database connectivity via native ODBC drivers supports 10+ major databases and data warehouses with no MCP servers required. Built-in support for CSV and XLSX files enables analysis across heterogeneous data sources from a single terminal interface.
Native dbt integration provides zero-config connection using existing dbt profiles, generates production-ready models from plain English requirements, automatically suggests and writes tests, and understands existing models and macros.