Run a read-only SQL query over HTTP GET

Run a read-only SQL query over HTTP GET

Use ClickHouse: its ClickHouse HTTP Interface API lets you run a read-only SQL query over HTTP GET in a single step (GET /). capabilities.work can help you get signed up and connected.

• How do I run a SELECT against ClickHouse by putting the SQL in the URL?
• Can I choose JSON or CSV output for a query sent as a GET request?
• Which database does a URL query run against if I don't set one?
• Does a bare GET on the server root just answer Ok. as a health check?

Say it to your AI assistant

• Run the query {query} through a GET request and return the rows.
• Execute {query} against database {database} via the URL and format the result as {default_format}.
• Run {query} as a GET request inside session {session_id} so temporary tables persist.

For your developer

GET / in ClickHouse HTTP Interface API. Full spec on APIs.io.