Hotdata API

✅ /v1/status (GET) - API status (no auth required)

🏥 /v1/healthcheck (GET) - API health status (no auth required)

🧱 /v1/workspaces (GET) - List workspaces

🧱 /v1/workspaces (POST) - Create workspace (provisioning)

🗂️ /v1/information_schema (GET) - List tables

🔍 /v1/query (POST) - Execute SQL query (returns result_id when persisted)

📦 /v1/results (GET) - List persisted query results

🧾 /v1/results/<id> (GET) - Retrieve a persisted query result by id

🔌 /v1/connections (GET) - List connections

➕ /v1/connections (POST) - Create connection

🔎 /v1/connections/<connection_id> (GET) - Get connection by id

🗑️ /v1/connections/<connection_id> (DELETE) - Delete connection

🧭 /v1/connections/<connection_id>/discover (POST) - Re-run schema discovery for a connection

🧹 /v1/connections/<connection_id>/cache (DELETE) - Purge cache for a connection

🔐 /v1/secrets (GET) - List secrets (metadata only)

➕ /v1/secrets (POST) - Create secret (metadata only)

🔏 /v1/secrets/<name> (GET) - Get secret metadata

♻️ /v1/secrets/<name> (PUT) - Update secret

🗑️ /v1/secrets/<name> (DELETE) - Delete secret

📊 /v1/datasets (GET) - List datasets

➕ /v1/datasets (POST) - Create dataset

🔎 /v1/datasets/<id> (GET) - Get dataset

♻️ /v1/datasets/<id> (PUT) - Update dataset

🗑️ /v1/datasets/<id> (DELETE) - Delete dataset

🚀 Hotdata API