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:
- Postgres wire protocol for compatibility with a range of clients
- Rest API which can be queried via HTTP
- Web Console which provides a code editor for convenience
You can query data using the Postgres endpoint
that QuestDB exposes. This is accessible via port
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.
Details for inserting data with the Web Console is covered on the insert data page. 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 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.