Pivotal code and generated Python shown side by side

Pivotal

A concise data analysis language for Python.

Install

Getting started

Install the Pivotal language and JupyterLab extension via pip and the VS Code extension via marketplace.

pip install pivotal-lang pivotal-lab

Syntax

Python data pipelines,
without the boilerplate

Write data transformations in concise, readable Pivotal syntax and run against common Python data backends (Pandas, Polars, DuckDB).

with players
    filter minutes >= 900
    goals_per_90 = goals / minutes * 90
    sort goals_per_90 desc
    select player, team, goals_per_90

Notebook and editor support

Use Pivotal in Jupyter and VS Code

Use Pivotal in either Jupyter Notebooks or VS Code with syntax highlighting, autocomplete, and visual data explorer / viewer.

Pivotal running in a JupyterLab Binder demo

MCP server

Generate Pivotal code with AI

Connect the public Pivotal MCP server to your AI agent, giving it access to concise Pivotal syntax descriptions, full Pivotal documentation, code generation checks and highlighting. Local MCP servers expose further execution and comparison tools for private data.

Hosted endpoint https://mcp.pivotal-lang.org/mcp MCP setup notes