# Tools

> Every listed resource, editors’ picks first. The filters below can be combined.

- Search: append `?q=<keywords>` to the URL. Separate several keywords with spaces; all of them must match. Matches name, repository, tags, professions, description and README.
- Filter by type: append `?type=<cli|skill|plugin|mcp>` to the URL.
- Filter by profession: append `?profession=<profession id>` to the URL. Separate several ids with commas; a resource matches when it suits any of them. Ids are listed at https://hebbmind.com/api/v1/professions
- Filter by tag: append `?tag=<tag>` to the URL. Separate several tags with commas; a resource must carry all of them. Tags are listed at https://hebbmind.com/api/v1/tags

Type CLI, Resources for Data analysis or Operations: 60 items.

> - Data analysis: Querying, statistical analysis, reporting and visualization.
> - Operations: Content, campaign, community, user and e-commerce operations, plus performance reviews.

- [yt-dlp](https://hebbmind.com/cli/yt-dlp.md): [CLI] Command-line audio and video downloader supporting thousands of sites: pick formats and quality, grab subtitles and metadata, and merge or transcode with FFmpeg. The actively maintained fork of youtube-dl.
- [DuckDB](https://hebbmind.com/cli/duckdb.md): [CLI] In-process analytical SQL database. Its CLI queries CSV, Parquet and JSON files directly with SQL, no import or server needed, so agents can sample and aggregate large files. Officially maintained.
- [Scrapling](https://hebbmind.com/cli/scrapling.md): [CLI] Adaptive web scraping framework: scrapling extract turns a page into Markdown, text or HTML in one command, with CSS selectors and browser rendering for dynamic pages, plus an MCP server (needs the ai extra). Needs Python 3.10+ and a browser install on first use.
- [Crawl4AI](https://hebbmind.com/cli/crawl4ai.md): [CLI] Open-source, LLM-friendly web crawler that turns pages into clean Markdown for RAG and agents. Ships the crwl CLI and supports deep crawling and question-driven data extraction (extraction needs an LLM key). Free to self-host.
- [OpenBB Platform CLI](https://hebbmind.com/cli/openbb-finance-cli.md): [CLI] Command-line edition of the open-source OpenBB investment research platform: query stock prices, financial statements, macroeconomic and other financial data from the terminal, and automate data pulls with Routine scripts. Officially maintained; some sources need API keys.
- [HyperFrames](https://hebbmind.com/cli/hyperframes.md): [CLI] Write videos in HTML, CSS and frame-seekable animations, preview them from the CLI and render deterministic MP4s. Comes with agent skills for product launch videos, captions and talking-head re-edits. Maintained by HeyGen; needs Node.js 22+ and FFmpeg.
- [Nushell](https://hebbmind.com/cli/nushell.md): [CLI] Cross-platform shell built around structured data: pipelines pass tables instead of plain text, and you can open and query JSON, CSV, TOML and more directly. Default builds include nu --mcp, which serves it to agents as an MCP server.
- [gws (Google Workspace CLI)](https://hebbmind.com/cli/googleworkspace-cli.md): [CLI] One CLI for Gmail, Drive, Calendar, Docs, Sheets and other Google Workspace APIs, with commands generated from the Discovery service, JSON output and 100+ Agent Skills. From the googleworkspace org but not officially supported; needs OAuth via a Google Cloud project.
- [OpenCLI](https://hebbmind.com/cli/opencli.md): [CLI] Turns websites and Electron desktop apps into deterministic CLIs, with built-in adapters for Reddit, Hacker News, Bilibili, Zhihu, Xiaohongshu and more, and lets agents operate any page through your signed-in Chrome. Needs its companion browser extension.
- [Rembg](https://hebbmind.com/cli/rembg.md): [CLI] Removes image backgrounds with one command: single images, whole folders or watched directories, mask-only output and switchable models like U2Net and SAM. Can also run as an HTTP server or process video frames with FFmpeg. Default models run locally.
- [gallery-dl](https://hebbmind.com/cli/gallery-dl.md): [CLI] Command-line tool for bulk-downloading galleries and posts from many image hosts and social platforms, with flexible file naming and config, and yt-dlp integration for video. Main development has moved to Codeberg; the GitHub repo stays in sync.
- [pyVideoTrans](https://hebbmind.com/cli/pyvideotrans.md): [CLI] All-in-one video translation and dubbing: chains speech recognition, subtitle translation, multi-speaker AI voiceover and audio-video muxing, with local or online models like Faster-Whisper, DeepSeek and Edge-TTS. cli.py supports headless batch runs. Needs FFmpeg.
- [lark-cli (Lark CLI)](https://hebbmind.com/cli/larksuite-cli.md): [CLI] Official Lark (Feishu) CLI with 200+ commands for messages, docs, Base, Sheets, calendar, mail, approvals, OKRs, meetings and Minutes, plus 20+ bundled lark-* agent skills and structured output. Create a Lark app and sign in first.
- [DataX](https://hebbmind.com/cli/datax.md): [CLI] Alibaba's open-source offline data sync tool: JSON job configs batch-sync between heterogeneous sources like MySQL, Oracle, PostgreSQL, Hive, HDFS and MaxCompute, run with python datax.py. Needs JDK 1.8+ and Python; download and unpack the official toolkit.
- [dbt](https://hebbmind.com/cli/dbt.md): [CLI] Command-line framework for warehouse modeling and ELT transformations: write models in SQL and let dbt handle dependencies, data tests and documentation. v2 is rewritten in Rust as a single binary. Maintained by dbt Labs; needs a data warehouse connection.
- [pgcli](https://hebbmind.com/cli/pgcli.md): [CLI] PostgreSQL command-line client with smart autocompletion and syntax highlighting. Compatible with psql environment variables, and -c runs a statement and exits, so agents can query databases non-interactively.
- [LLM](https://hebbmind.com/cli/llm.md): [CLI] Simon Willison's LLM CLI and Python library: call OpenAI, Claude, Gemini and local models from the terminal, with conversations logged to SQLite automatically, plus embeddings, structured extraction, tool calling and a plugin system.
- [mycli](https://hebbmind.com/cli/mycli.md): [CLI] MySQL terminal client with smart autocompletion and syntax highlighting, also compatible with MariaDB and TiDB. Supports --execute and batch mode with CSV or table output, so agents can run SQL directly.
- [Streamlink](https://hebbmind.com/cli/streamlink.md): [CLI] Pipes live streams from Twitch, YouTube and many other platforms to a local player, or saves them to video files with --output or --record, for keeping and re-editing replays of your own or partners' streams. Viewing needs a player like VLC. Only record content you have rights to.
- [Datasette](https://hebbmind.com/cli/datasette.md): [CLI] Publishes SQLite databases as browsable, queryable web pages and JSON APIs, with SQL queries, metadata and plugins, and deploys to Cloud Run and other platforms with datasette publish. Great for data exploration and data journalism. Needs Python 3.10+.
- [pdfplumber](https://hebbmind.com/cli/pdfplumber.md): [CLI] Reads the exact position of every character, line and table cell in digital PDFs: the CLI exports layout-preserving text or CSV/JSON details, and the Python API extracts tables and form fields, ideal for invoices, statements and reports. Runs locally with Python; scans need OCR first.
- [usql](https://hebbmind.com/cli/usql.md): [CLI] Universal psql-style SQL command line: one tool to connect to PostgreSQL, MySQL, SQLite, SQL Server, Oracle and dozens of other SQL and NoSQL databases, with support for copying data between databases.
- [Miller](https://hebbmind.com/cli/miller.md): [CLI] Processes CSV, TSV, JSON and other structured data like awk, sed, cut, join and sort, but by field name, for cleaning, aggregation, format conversion and pretty-printing. The command is mlr; written in Go with no runtime dependencies.
- [SQLFluff](https://hebbmind.com/cli/sqlfluff.md): [CLI] Linter and formatter for 20+ SQL dialects that auto-fixes most issues and handles Jinja templating and dbt projects (dbt needs a plugin), suited to warehouse code review and CI.
- [VisiData](https://hebbmind.com/cli/visidata.md): [CLI] Terminal tool for exploring and wrangling tabular data: opens dozens of formats including CSV, JSON, Excel and SQLite for filtering, sorting, pivots and frequency counts. --batch mode replays actions headlessly or converts file formats.
- [gog (gogcli)](https://hebbmind.com/cli/gogcli.md): [CLI] Google Workspace CLI for scripts and agents covering Gmail, Calendar, Drive, Docs, Sheets, Contacts and Tasks, with JSON output, read-only mode and command allowlists; can also run as a read-only-by-default MCP server. Bring your own Google OAuth client.
- [BackgroundRemover](https://hebbmind.com/cli/backgroundremover.md): [CLI] Removes backgrounds from images and videos with one AI command: batch whole folders, use a portrait model, refine edges or swap in a solid color, and output transparent MOV or composite video onto a new background. Runs locally; install PyTorch and ffmpeg first. Models download on first run.
- [Steampipe](https://hebbmind.com/cli/steampipe.md): [CLI] Query cloud resources and SaaS APIs live with SQL: plugins map AWS, Azure, GCP, GitHub, Kubernetes and other services to tables you can select from directly, no ETL needed. A single binary with Postgres built in.
- [Jupytext](https://hebbmind.com/cli/jupytext.md): [CLI] Converts and two-way syncs Jupyter notebooks with plain Python scripts or Markdown, so agents can edit research and teaching notebooks like ordinary text and diffs stay readable. Needs a local Python environment; install with pip.
- [Trafilatura](https://hebbmind.com/cli/trafilatura.md): [CLI] Python library and CLI for extracting main web content: fetches pages, crawls via sitemaps and RSS feeds, strips headers, footers and other noise, and outputs TXT, Markdown, JSON, XML and more with metadata. Also processes downloaded HTML offline.
- [csvkit](https://hebbmind.com/cli/csvkit.md): [CLI] Veteran suite of CSV command-line tools: in2csv converts Excel and JSON to CSV, csvcut, csvgrep and csvsort filter and sort, csvstat computes statistics, and csvsql runs SQL directly against CSV files.
- [Quarto](https://hebbmind.com/cli/quarto-cli.md): [CLI] Posit's open-source scientific and technical publishing system built on Pandoc: embed Python, R or Julia code in Markdown or Jupyter notebooks, then quarto render produces HTML, PDF, Word, slides, websites and books.
- [pngquant](https://hebbmind.com/cli/pngquant.md): [CLI] Lossy PNG compression CLI: converts images to 8-bit PNGs that keep transparency, usually 60-80% smaller, with batch processing and a quality range setting. Handy for slimming down web assets, slides and article images. Install via Homebrew on macOS; no account.
- [gifski](https://hebbmind.com/cli/gifski.md): [CLI] High-quality GIF encoder built on pngquant: turns video frames or PNG sequences into animations, using cross-frame palettes and temporal dithering for thousands of colors per frame. Can take video piped straight from ffmpeg.
- [Auto-Editor](https://hebbmind.com/cli/auto-editor.md): [CLI] Automatically cuts silent or static parts from video and audio based on loudness or motion, with adjustable margins and speed changes, and exports project files for Premiere, DaVinci Resolve, Final Cut Pro and other editors. The repo ships an agent skill.
- [WP-CLI](https://hebbmind.com/cli/wp-cli.md): [CLI] WordPress's official CLI: install and update plugins and themes, manage posts and users, import and export content, run database search-replace and configure multisite from the terminal, without opening wp-admin. Requires PHP 7.2.24 or later.
- [YouPlot](https://hebbmind.com/cli/youplot.md): [CLI] Draws bar charts, histograms, line charts, scatter plots and box plots in the terminal from CSV/TSV on stdin, so you can glance at data distributions at the end of a shell pipeline. The command is uplot.
- [AiPy](https://hebbmind.com/cli/aipyapp.md): [CLI] Knownsec's open-source Python-use agent: describe a task in plain language and it writes and runs Python on your machine, e.g. tidying Excel files, summarizing attendance or screening resumes. Needs Python 3.11+ and a model API key such as DeepSeek; code runs locally, so back up important files.
- [Camelot](https://hebbmind.com/cli/camelot.md): [CLI] Open-source PDF table extraction with a camelot CLI: exports tables from financial reports, bank statements and statistical reports to Excel, CSV or Markdown, with an accuracy score. Needs Python 3.10+; handles text-based PDFs by default, scans need the ml and ocr extras. Double-check results.
- [qsv](https://hebbmind.com/cli/qsv.md): [CLI] Fast Rust toolkit for tabular data with nearly 80 subcommands for querying, stats, cleaning, validation, joins and format conversion on CSV and Excel. Also offers an MCP server and a Claude Cowork plugin.
- [SQLMesh](https://hebbmind.com/cli/sqlmesh.md): [CLI] Framework for writing data transformation models in SQL or Python, with a Terraform-like plan/apply flow, virtual data environments, unit tests and table diffs, and transpilation across 10+ SQL dialects. A Linux Foundation project and an alternative to dbt.
- [Rill](https://hebbmind.com/cli/rill.md): [CLI] Open-source, agent-friendly BI: define metrics and dashboards in YAML and SQL, and rill init generates project instructions and MCP config for Claude Code so agents can build business dashboards and answer questions in natural language. Local use is free; publishing to Rill Cloud needs an account.
- [wacli](https://hebbmind.com/cli/wacli.md): [CLI] WhatsApp CLI: pair as a linked device, sync messages to local SQLite, search offline, send text and files, and manage groups, with --json output for agents. Built on the unofficial WhatsApp Web protocol.
- [shot-scraper](https://hebbmind.com/cli/shot-scraper.md): [CLI] Simon Willison's website screenshot CLI: batch screenshots from YAML, record demo videos, export PDF and HTML, run JavaScript in pages to extract data, and dump accessibility trees. Built on Playwright; install a browser on first use.
- [MiniMax CLI (mmx)](https://hebbmind.com/cli/minimax-ai-cli.md): [CLI] MiniMax's official CLI, built for agents: chat with MiniMax models from the terminal and generate images, video and speech, plus speech transcription, image understanding and web search. Works with the international platform. Requires a MiniMax Token Plan subscription.
- [sqlite-utils](https://hebbmind.com/cli/sqlite-utils.md): [CLI] A CLI and Python library by Simon Willison: imports JSON and CSV straight into SQLite with automatic table creation, runs in-memory SQL queries over files, and supports full-text search and table transformations.
- [Gorgias CLI (Printing Press)](https://hebbmind.com/cli/gorgias.md): [CLI] Unofficial Gorgias CLI built with Printing Press for e-commerce support: lets AI list, reply to and update tickets, look up customers, find stale or incomplete tickets, and sync data locally for full-text search and SQL. Includes a skill and MCP server. Needs a Gorgias account and API key.
- [Intercom CLI (Printing Press)](https://hebbmind.com/cli/intercom.md): [CLI] Unofficial Intercom CLI built with Printing Press, covering the full REST API: sync conversations and contacts for offline search, bulk-tag conversations about one incident, see customer overviews and SLA reports, and pull or push help articles. US, EU and AU regions; needs an access token.
- [stock-api](https://hebbmind.com/cli/stock-api.md): [CLI] Fetches US, Hong Kong and China A-share stock data with zero runtime dependencies: real-time quotes, daily, weekly and monthly candles and search as JSON, falling back across Tencent, Sina and Eastmoney sources. Also runs as an MCP server. Unofficial public APIs, no stability guarantee.
- [feishu-cli](https://hebbmind.com/cli/feishu-cli.md): [CLI] Community CLI for Feishu (Lark) focused on two-way conversion between Markdown and Feishu docs; also works with wikis, sheets, Bitable, messages, calendar, tasks and meeting notes, and ships 9 agent skills. Setup creates an app via QR scan; search and mail need extra user authorization.

Next page: https://hebbmind.com/tools.md?page=2&type=cli&profession=data%2Coperations
