Joltio Data / API
Connect to Joltio Data
One key per person gives you the whole catalog from Python, HTTP or your pipeline. Claude connects with your Joltio account, no key needed.
- Data API
api.joltio.app/data- MCP server
api.joltio.app/mcp- Authentication
X-API-Key or Bearer
OpenAPI 3.1 · /data/openapi.json
- 01
Get an API key
Create a key in the panel, under Data, API keys. Keys start with jol_live_ and are shown only once, so store them in your secret manager and never in code.
Send it in every request with either header
HTTP headers X-API-Key: jol_live_… Authorization: Bearer jol_live_…Start free No workspace yet? Start free - 02
Connect Claude
Add Joltio as a custom connector. Claude signs you in with your Joltio account through OAuth, so there is no key to paste.
In Claude, open Settings, Connectors, Add custom connector, and paste this URL
MCP URL https://api.joltio.app/mcp - 03
Connect ChatGPT
Add Joltio as a custom MCP app. ChatGPT signs you in with your Joltio account through OAuth, so there is no key to paste. Custom MCP apps need developer mode and are available on ChatGPT Business, Enterprise and Edu (web).
- Turn on developer mode: Settings, Apps, Advanced settings, Developer mode (on Business, a workspace admin does it in Workspace settings, Apps, Create).
- Open Settings, Apps, Create, and paste this MCP server URL. Choose OAuth as the authentication.
MCP URL https://api.joltio.app/mcp- Click Scan Tools, sign in with your Joltio account when asked, wait for the scan and click Create.
- In a new chat, pick the app from the tools menu and ask about the electricity market.
- 04
Use it from any chat or agent
Once Claude or ChatGPT is connected you do not need to write code or install a plugin. The connector provides the Joltio skills your workspace allows through skills_get and MCP resources. The assistant loads them on demand and checks your plan with data_status before querying.
Things you can ask
- What tables and date ranges does my plan include?
- Read the Joltio Data guide and explain how to get hourly OMIE prices.
- Show me yesterday's day-ahead price by hour and chart it.
Chat without a connector, or a coding agent? Share this address so it can read the documentation:
llms.txt https://joltio.app/llms.txtThe same file lists the MCP address and how to authenticate, so an agent can set itself up from it.
Optional local installation for Claude Code, Codex and Cursor: Joltio skills. Claude Code installs the skills and MCP connector together; Codex and Cursor configure them separately. The connector alone already serves the skills. github.com/datons/joltio-skills
- 05
Terminal
Install the Joltio command and sign in through your browser. Your session renews while you use it.
Terminal uv tool install joltio joltio login joltio data query "SELECT max(datetime) FROM omie.prices" - 06
Python with browser login
Install the same package in your Python environment, sign in once and use Client() without copying a key. Use an API key for CI or shared notebooks.
Python with browser login pip install joltio joltio login python -c "from joltio import Client; print(Client().data.query('SELECT max(datetime) FROM omie.prices'))" - 07
Local MCP for Claude Code
The hosted MCP needs no installation. To run it locally, install the optional MCP extra and register the command.
Local MCP for Claude Code uv tool install "joltio[mcp]" joltio login claude mcp add joltio -- joltio mcp - 08
Query from Python
The joltio client reads JOLTIO_API_KEY and returns polars DataFrames.
Install pip install joltio # or: uv add joltioPython · Example from joltio import Client j = Client() # reads JOLTIO_API_KEY df = j.data.query("SELECT max(datetime) FROM omie.prices WHERE datetime >= today() - 7") print(df) - 09
Python in VS Code
Generate your key, download the folder and open it in VS Code. Your key goes in .env, never inside the notebook.
Download the folder (zip) 15-cell notebook · .env, .env.example, AGENTS.md for your AI assistant and README includedHow the folder should look
Unzip it and open the folder in VS Code. Keep the files together: the notebook looks for .env in the folder it runs from.
joltio-quickstart/joltio-quickstart.ipynbThe notebook. Open it in VS Code and choose your Python environment as the kernel.investiga-una-unidad.ipynbSecond notebook: one programming unit (CTGN1, Cartagena) from the day-ahead market to its final schedule, with interactive charts and a treemap..envYour private settings, empty on purpose. Paste your API key here. Never share it or commit it to a repository..env.exampleThe same template without the key. Safe to share; if you lose .env, copy this one and fill it in again.AGENTS.mdInstructions for AI assistants working in this folder.CLAUDE.mdPoints Claude Code to AGENTS.md.README.mdSetup instructions for the notebook and its local configuration.
Files that start with a dot are hidden by default in Finder and Explorer; VS Code shows them.
Install the client in the Python environment VS Code uses pip install joltio python-dotenv ipykernel matplotlib plotly nbformatTerminal joltio data quickstart joltio-quickstartPaste your key in .env JOLTIO_API_KEY=jol_live_…The zip already includes .env, empty on purpose: put the key right after JOLTIO_API_KEY= and save.
Open the notebook, choose that environment as the kernel and run the first cell.
Corporate networksIf your company inspects HTTPS traffic, Python does not recognise its certificate and the first query fails with an SSL certificate error. Ask IT for the root certificate in PEM format and point to it in the same .env: SSL_CERT_FILE is what the joltio client reads, and REQUESTS_CA_BUNDLE covers pip and libraries built on requests.
Lines to add to .env SSL_CERT_FILE=C:\certs\company-root-ca.pem REQUESTS_CA_BUNDLE=C:\certs\company-root-ca.pem - 10
Call the HTTP API
Any language works: send SQL to /data/query, or check coverage and freshness, which needs no key.
SQL query curl https://api.joltio.app/data/query \ -H "X-API-Key: $JOLTIO_API_KEY" \ -H "User-Agent: my-app/1.0" \ -H "Content-Type: application/json" \ -d '{"sql": "SELECT max(datetime) FROM omie.prices WHERE datetime >= today() - 7"}'Coverage (public) curl "https://api.joltio.app/data/coverage?table=omie.prices" \ -H "User-Agent: my-app/1.0"Always send an identifying User-Agent. Requests with default library agents are rejected with 403.
Included
Data is included with every Joltio product: a short history window and a small monthly quota. Upgrade for more history, raw I90 and more credits.
GET https://api.joltio.app/data/tier-info Upgrade