Skip to content
PuckAPI

Integrations

PuckAPI works where you already work

One account, one set of 500 free monthly credits, and the same 28 tools in your AI assistant, your editor, your spreadsheet or your own code.

Get a free keyMCP setup, step by step

AI assistants

Coding tools

Spreadsheets

Code

Excel, with Power Query

Data, Get Data, From Other Sources, Blank Query, then Advanced Editor. Paste this, put your key in place of YOUR_API_KEY, and choose Close & Load. Refresh pulls fresh data. To pass parameters, write them as JSON in the Content line, for example Text.ToBinary("{""season"":2025}") (Power Query doubles quotes inside text). Each refresh is one call and uses its credits.

text
let
    Response = Json.Document(Web.Contents("https://mcp.puckapi.com/v1/list_teams", [
        Headers = [#"x-api-key" = "YOUR_API_KEY", #"Content-Type" = "application/json"],
        Content = Text.ToBinary("{}")
    ])),
    // The first list in the answer becomes the table
    Rows = List.First(List.Select(Record.FieldValues(Response[data]), each Value.Is(_, type list))),
    Table = Table.FromRecords(Rows)
in
    Table

Everything uses the same account

Whichever way you connect, calls use the same credits at the same price: free each month, then a plan or a top-up from the pricing page. The server URL is https://mcp.puckapi.com/mcp; the REST base is https://mcp.puckapi.com.