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

  1. 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
  2. 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
  3. 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).

    1. Turn on developer mode: Settings, Apps, Advanced settings, Developer mode (on Business, a workspace admin does it in Workspace settings, Apps, Create).
    2. Open Settings, Apps, Create, and paste this MCP server URL. Choose OAuth as the authentication.
    MCP URL
    https://api.joltio.app/mcp
    1. Click Scan Tools, sign in with your Joltio account when asked, wait for the scan and click Create.
    2. In a new chat, pick the app from the tools menu and ask about the electricity market.
  4. 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.txt

    The 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

  5. 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"
  6. 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'))"
  7. 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
  8. 08

    Query from Python

    The joltio client reads JOLTIO_API_KEY and returns polars DataFrames.

    Install
    pip install joltio        # or: uv add joltio
    Python · 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)
  9. 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 included

    How 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 nbformat
    Terminal
    joltio data quickstart joltio-quickstart
    Paste 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 networks

    If 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. 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

Plan

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.

Check your plan and limits with GET https://api.joltio.app/data/tier-info Upgrade