This page describes how to query data from QuestDB using different programming languages and tools. To query data in a running instance, there are three main methods that can be used:
- Web Console which provides a code editor, table schema explorer and a data visualization panel
- Rest API which can be queried via HTTP
- Postgres wire protocol for compatibility with a range of clients
QuestDB ships with an embedded Web Console running by default on port
To query data from the web console, SQL statements can be written in the code editor and executed by clicking RUN.
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 reference page.
You can query data using the REST API, this will
work with a very wide range of libraries and tools. The REST API is accessible
More information on the available endpoints alongside possible parameters and usage examples can be found on the REST API reference page.
You can query data using the Postgres endpoint
that QuestDB exposes which is accessible by default via port