Query data

This page describes how to query data from QuestDB using different programming languages and tools.


For ad-hoc SQL queries, including CSV download and charting use the web console. Applications can choose between the HTTP REST API which returns JSON or use the PostgreSQL wire protocol.

QuestDB supports the following data querying methods:

  • HTTP REST API: compatibility with a wide range of libraries and tools.
    • Accessing QuestDB via the Web Console:
      • SQL SELECT statements.
      • Download query results as CSV.
      • Chart query results.
    • SQL SELECT statements as JSON or CSV
    • Result paging
  • PostgreSQL wire protocol: interoperability with the PostgreSQL ecosystem.
    • SQL SELECT statements.
    • Use psql on the command line.

Web Console#

QuestDB ships with an embedded Web Console running by default on port 9000.

Screenshot of the Web Console

To query data from the web console, SQL statements can be written in the code editor and executed by clicking the Run button.

Listing tables and querying a table
SELECT * FROM my_table;
--Note that `SELECT * FROM` is optional

Aside from the Code Editor, the Web Console includes a data visualization panel for viewing query results as tables or graphs and an Import tab for uploading datasets as CSV files. For more details on these components and general use of the console, see the Web Console page.

PostgreSQL wire protocol#

You can query data using the Postgres endpoint that QuestDB exposes which is accessible by default via port 8812. Examples in multiple languages are shown below. To learn more, check out our docs about Postgres compatibility and tools.

import psycopg as pg
import time
# Connect to an existing QuestDB instance
conn_str = 'user=admin password=quest host= port=8812 dbname=qdb'
with pg.connect(conn_str, autocommit=True) as connection:
# Open a cursor to perform database operations
with connection.cursor() as cur:
#Query the database and obtain data as Python objects.
cur.execute('SELECT * FROM trades_pg;')
records = cur.fetchall()
for row in records:
# the connection is now closed


QuestDB exposes a REST API for compatibility with a wide range of libraries and tools. The REST API is accessible on port 9000 and has the following query-capable entrypoints:

EntrypointHTTP MethodDescriptionAPI Docs
/exp?query=..GETExport SQL Query as CSVReference
/exec?query=..GETRun SQL Query returning JSON result setReference

For details such as content type, query parameters and more, refer to the REST API docs.

/exp: SQL Query to CSV#

The /exp entrypoint allows querying the database with a SQL select query and obtaining the results as CSV.

For obtaining results in JSON, use /exec instead, documented next.

curl -G --data-urlencode \
"query=SELECT * FROM example_table2 LIMIT 3" \

/exec: SQL Query to JSON#

The /exec entrypoint takes a SQL query and returns results as JSON.

This is similar to the /exec entry point which returns results as CSV.

Querying Data#

curl -G \
--data-urlencode "query=SELECT x FROM long_sequence(5);" \

The JSON response contains the original query, a "columns" key with the schema of the results, a "count" number of rows and a "dataset" with the results.

"query": "SELECT x FROM long_sequence(5);",
"columns": [{ "name": "x", "type": "LONG" }],
"dataset": [[1], [2], [3], [4], [5]],
"count": 5

โญ Something missing? Page not helpful? Please suggest an edit on GitHub.