Use with AI · SQL · API

One key. Three ways to use it.

Plug Renavon into Claude Desktop, Cursor, ChatGPT, or any HTTP client. Same datasets, same warehouse, sub-second queries.

Connection details updated — MotherDuck retired 2026-05-04

Your API key is unchanged. If you previously connected via mcp-server-clickhouse with a MotherDuck token, you now use the REST API below (or any HTTP client). See the three ways to access Hong Kong data guide for the migration path.

Step 1

Your API key

Authenticate with an API key. Free account, no credit card.

POST https://renavon.com/api/v1/query
Get your API key
Step 2

Plug it in

Paste this into ~/Library/Application Support/Claude/claude_desktop_config.json on macOS, or the equivalent on Windows. Restart Claude Desktop.

{
  "mcpServers": {
    "renavon": {
      "command": "npx",
      "args": ["-y", "@renavon/mcp-server"],
      "env": {
        "RENAVON_API_KEY": "YOUR_API_KEY"
      }
    }
  }
}

Once connected, ask Claude things like "What were last weekend's Sha Tin winners?" — it'll write the SQL itself.

Step 3

Your tables

Query tables in the renavon_exports database. Example tables:

hkjc_races
SELECT * FROM hkjc_races LIMIT 10
hkjc_horses
SELECT * FROM hkjc_horses LIMIT 10
crhk_companies
SELECT * FROM crhk_companies LIMIT 10

Create a free account to see your tables.