Connect to Your Data

Use DuckDB to query your datasets with Python, DBeaver, or any SQL client

Looking to download data without coding?

Visit any dataset page to download sample data in CSV or Excel format.

Your Databases

Each database contains a main schema with your data tables. Example databases:

renavon_hkjc_races
Query: SELECT * FROM renavon_hkjc_races.main.hkjc_races LIMIT 10
renavon_hkjc_horses
Query: SELECT * FROM renavon_hkjc_horses.main.hkjc_horses LIMIT 10
renavon_crhk_companies
Query: SELECT * FROM renavon_crhk_companies.main.crhk_companies LIMIT 10

Create a free account to see your databases.

Connection Token

Connect to MotherDuck with a session token. Here is the connection string format:

md:?motherduck_token=YOUR_TOKEN

Create a free account to get your connection token.

How to Connect

Table Naming Pattern

All tables follow this pattern:

renavon_DATASET.main.DATASET

Example: renavon_hkjc_horses.main.hkjc_horses

Python 

import duckdb

# Connect with your token (copy from above)
conn = duckdb.connect("md:?motherduck_token=YOUR_TOKEN")

# List available databases
print(conn.sql("SHOW DATABASES").fetchall())

# Query a dataset (replace DATABASE and TABLE with your values)
result = conn.sql("""
    SELECT * FROM renavon_DATABASE.main.TABLE LIMIT 10
""")
print(result.fetchall())

Tip: Use .fetchdf() for pandas DataFrame or .fetchall() for raw tuples.

DBeaver / DataGrip / SQL Clients

  1. Install the DuckDB driver for your client
  2. Create a new DuckDB connection
  3. Set the database path to your connection string (copy from above)
  4. Connect and browse your databases in the schema explorer

AI Agents (Claude, Cursor, VS Code)

Connect AI assistants to your Renavon data using the Model Context Protocol (MCP).

  1. Get a session token using the button above
  2. Install the MotherDuck MCP server: uvx mcp-server-motherduck
  3. Add this to your Claude Desktop config (claude_desktop_config.json):
{
  "mcpServers": {
    "renavon": {
      "command": "uvx",
      "args": ["mcp-server-motherduck"],
      "env": {
        "motherduck_token": "YOUR_TOKEN_FROM_ABOVE"
      }
    }
  }
}

Cursor and VS Code use the same config format. See the full setup guide for details.

Autonomous Agents (Manus, ChatGPT, Devin)

Autonomous AI agents like Manus AI can query your Renavon data directly — no MCP configuration needed. Give the agent your API key and database names, describe what you want in plain language, and it handles the rest: authenticating, connecting, writing SQL, and returning results.

Works with any agent that can execute Python. See how autonomous agents work with Renavon data for details and tips.

Example AI Prompts

Try these prompts with your AI assistant after connecting:

  • » "Using my Renavon data, show the top 10 jockeys by win rate this season"
  • » "Find all companies registered in Hong Kong in the last 30 days"
  • » "Chart the odds movement for the favourite in the most recent race"
  • » "List all SFC licensed persons whose licence was suspended this year"

API Key (for automation)

rnvn_xxxxxxxxxxxx

Create a free account to get your API key for programmatic access via POST /api/v1/session-token