explaingit

microsoft/data-formulator

Analysis updated 2026-06-24

15,549TypeScriptAudience · dataComplexity · 3/5Setup · moderate

TLDR

Data Formulator is a Microsoft Research tool that lets you build charts and explore data by describing what you want in plain English, connect to a spreadsheet, database, or cloud source and let AI agents create the visualizations.

Mindmap

mindmap
  root((Data Formulator))
    What it does
      Chart generation
      Data exploration
      Report building
    Data sources
      Spreadsheets
      SQL databases
      Cloud stores
    Interaction modes
      Natural language
      UI drag and drop
      Agent conversation
    Chart types
      30 plus types
      Area and streamgraph
      Maps and radar
Click or tap to explore — scroll the page freely

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

What do people build with it?

USE CASE 1

Turn a spreadsheet or CSV into interactive charts by describing what you want in plain English

USE CASE 2

Connect to live databases like MySQL, PostgreSQL, or BigQuery and build visualizations without writing queries

USE CASE 3

Restyle existing charts using natural-language instructions about colors, fonts, and layout

USE CASE 4

Build shareable data reports with persistent sessions that reconnect to live sources across restarts

What is it built with?

TypeScriptPythonDockerLiteLLM

How does it compare?

microsoft/data-formulatorinfinitered/reactotrongetmaxun/maxun
Stars15,54915,54315,564
LanguageTypeScriptTypeScriptTypeScript
Setup difficultymoderateeasymoderate
Complexity3/52/53/5
Audiencedatadeveloperdata

Figures from each repo's GitHub metadata at analysis time.

How do you get it running?

Difficulty · moderate Time to first run · 30min

Requires an API key for OpenAI, Azure, Anthropic, or a locally running Ollama instance.

In plain English

Data Formulator is a tool from Microsoft Research that helps people explore and visualize data using AI agents. The problem it tackles is that turning raw data, a spreadsheet, a screenshot, a chunk of text, or the contents of a database, into useful charts and reports normally takes a fair bit of fiddling with software. Data Formulator lets you start from data in almost any of those shapes and then talk to AI agents to build visualizations and reports around it. The interface blends two ways of working: clicking and dragging in the user interface, and writing requests in natural language. You can ask visualization questions, edit charts directly, or hand exploration tasks off to an agent that keeps track of what you have been doing across the conversation. The latest release adds persistent connections to outside data sources including Superset, Kusto, Cosmos DB, MySQL, PostgreSQL, MSSQL, S3, Azure Blob and BigQuery, plus single sign-on and sessions that survive restarts. The chart engine supports more than 30 chart types, area, streamgraph, candlestick, pie, radar and maps among them, and a separate style-refinement agent can restyle a rough chart through plain-English instructions about typography, color, layout and annotations. You would use Data Formulator if you want to explore a dataset or build a shareable report without writing visualization code by hand. It is a Python package installable through pip or the faster uv installer, and also runs via Docker or GitHub Codespaces, it connects to AI models from OpenAI, Azure, Ollama and Anthropic through a library called LiteLLM. The full README is longer than what was provided.

Copy-paste prompts

Prompt 1
I have a CSV with sales data by region and month. Use Data Formulator to create a streamgraph showing how each region's sales trend over time, describe the steps I take in the UI.
Prompt 2
I want to connect Data Formulator to my PostgreSQL database. Walk me through setting up the connection and then asking it to chart monthly active users.
Prompt 3
I have a rough bar chart in Data Formulator but the colors are wrong and the axis labels are unclear. What natural-language instructions can I give the style-refinement agent to fix it?
Prompt 4
What AI model backends does Data Formulator support through LiteLLM, and how do I configure it to use a local Ollama model instead of OpenAI?

Frequently asked questions

What is data-formulator?

Data Formulator is a Microsoft Research tool that lets you build charts and explore data by describing what you want in plain English, connect to a spreadsheet, database, or cloud source and let AI agents create the visualizations.

What language is data-formulator written in?

Mainly TypeScript. The stack also includes TypeScript, Python, Docker.

How hard is data-formulator to set up?

Setup difficulty is rated moderate, with roughly 30min to a first successful run.

Who is data-formulator for?

Mainly data.

Open on GitHub → Explain another repo

This repo across BitVibe Labs

Verify against the repo before relying on details.