Install
Get started with Pivotal
Install the Pivotal language and JupyterLab extension via pip and the
VS Code extension
via marketplace.
pip install pivotal-lang pivotal-lab
Syntax
Readable pipelines that compile to Python
Write transformations in a compact DSL 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
players = players[players["minutes"] >= 900].copy()
players["goals_per_90"] = players["goals"] / players["minutes"] * 90
players = (
players
.sort_values("goals_per_90", ascending=False)
[["player", "team", "goals_per_90"]]
)
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.