Tools

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.

Unified search across 20+ academic sources including arXiv, PubMed, bioRxiv, Semantic Scholar and OpenAlex, returning deduplicated, normalized results and downloading full text via open-access channels first. Most sources need no API key.

Python library with a built-in MCP server for US SEC EDGAR data: search 10-K, 10-Q, 8-K and other filings and read XBRL-standardized financial statements, Form 4 insider trades and 13F holdings. Free with no API key; just set an EDGAR_IDENTITY.

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.

Runs open image models like FLUX, Qwen Image and Z-Image locally on a Mac: text-to-image, reference-based edits, inpainting and upscaling, all on-device. Needs Apple Silicon and uv; the first run downloads models and is slow. Check each model's license before commercial use.

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.

Self-hostable long-term memory for agents, offering MCP, a REST API and a web dashboard: semantic search, knowledge graph and automatic memory consolidation. Embeddings are computed locally; choose SQLite, Cloudflare or Milvus as the backend.

A three-stage workflow for math modeling contests like MCM/ICM and CUMCM: analysis, solving and plotting in Python or MATLAB, and a Word (optionally LaTeX) paper, with stage-check subagents and OpenAlex plus AnySearch literature search. Generated papers are for reference only.

Gives agents controlled access to MySQL: list databases and tables, inspect schemas and sample data, and run SQL, with multi-database mode, SSL and SSH tunnels. Configure your own database user, ideally with least privilege.

Connects agents to live Jupyter notebooks: read, write, insert and execute cells and read multimodal outputs like charts, for interactive data analysis. Bring your own JupyterLab or JupyterHub; open source, maintained by Datalayer.

LangChain's official skill collection: framework selection, quickstarts, middleware, persistence, human-in-the-loop approval, RAG and eval design across LangChain, LangGraph and Deep Agents, in Python and TypeScript. Also installable as a Claude Code plugin. Still in early development.

The standard machine translation scorer: computes BLEU, chrF and TER with significance tests and downloads public test sets such as WMT, to compare engines or prompts. Needs Python 3.9+ and reference translations; automatic metrics are a rough screen, so final copy still needs human review.

Lets agents query Google Ads accounts, campaigns and performance data with GAQL; currently read-only tools only. Maintained by Google; needs Google Cloud credentials and Google Ads API access.

ComfyUI's official CLI: install and launch ComfyUI in one step, manage custom nodes and model downloads, and run image and video workflows, with --json output on every command for agents. Can also submit jobs to paid Comfy Cloud.

Lets agents read and write Google Sheets: list and search spreadsheets, read and batch-update cells, insert rows and columns, create and share sheets and build charts, with the option to enable only some tools to save context. Needs a Google Cloud service account or OAuth credentials.

Plotting skills for academic papers: bar, line, scatter, radar and other styles distilled from 9 real paper figures. Plot your own data in a chosen style as 300 dpi figures, or reproduce a matplotlib script from a paper screenshot. Needs local Python and matplotlib.

The Docling project's official MCP: converts PDF, Word, PowerPoint and more into structured documents with layout and table detection and OCR for scans, and lets agents build new documents paragraph by paragraph and export Markdown. Local mode needs Python and uv, or use your own Docling Serve.

Stock analysis MCP for individual investors: quotes via yfinance, technical indicators such as RSI and MACD, screening strategies, a portfolio tracker and a trade journal. Core tools need no API key; backtesting and deep-research extensions are optional.

Redis's official MCP server: read and write strings, hashes, lists, streams, JSON and other data structures in natural language, with vector indexing and search and pub/sub. Bring your own Redis instance; runs via uvx.

Chroma's official MCP: lets agents create and manage collections, add documents, and retrieve them with vector search, full-text search and metadata filters. Connects to in-memory or local persistent stores, self-hosted instances or Chroma Cloud.

Apache Doris's official MCP: gives agents read-only access to explore table metadata, run and explain SQL, diagnose slow queries, and check cluster status, load jobs and data governance info. Needs Python 3.12+ and Doris 2.0 or later.

MinerU's official MCP: parses PDF, Word, PowerPoint and images into Markdown via the mineru.net cloud API, keeping tables and formulas. The keyless Flash mode works out of the box; add a token for higher quotas and more formats.