Questdb
QuestDB is a high performance, open-source, time-series database
Install / Use
/learn @questdb/QuestdbREADME
QuestDB is an open-source time-series database offering blazingly fast ingestion and dynamic, low-latency SQL queries.
QuestDB delivers a multi-tier storage engine (WAL → native → Parquet on object storage), and the core engine is implemented in zero-GC Java and C++; QuestDB Enterprise includes additional components in Rust.
We achieve high performance via a column-oriented storage model, parallelized vector execution, SIMD instructions, and low-latency techniques. In addition, QuestDB is hardware efficient, with quick setup and operational efficiency.
<p> </p> <div align="center"> <a href="https://demo.questdb.com/"> <img alt="QuestDB Web Console showing a SQL statement and query result" src="https://raw.githubusercontent.com/questdb/questdb/master/.github/console.png" width="900" /> </a> <p><em>QuestDB Web Console - click to launch demo</em></p> </div> <p> </p>Ready to go? Jump to the Get started section.
Benefits of QuestDB
Feature highlights include:
- Low-latency, high-throughput ingestion — from single events to millions/sec
- Low-latency SQL with time-series extensions (ASOF JOIN, WINDOW JOIN, HORIZON JOIN, SAMPLE BY, LATEST ON)
- SIMD-accelerated, parallel execution
- Multi-tier storage: WAL → native columnar → Parquet (time-partitioned and time-ordered)
- Postgres protocol (PGwire) and REST API
- Materialized views and n-dimensional arrays (incl. 2D arrays for order books)
- Web console for queries and data management
- Apache 2.0 open source and open formats — no vendor lock-in
- Finance functions and orderbook analytics
QuestDB excels with:
- financial market data (tick data, trades, order books, OHLC)
- Sensor/telemetry data with high data cardinality
- real-time dashboards and monitoring
And why use a time-series database?
Beyond performance and efficiency, with a specialized time-series database, you don't need to worry about:
- out-of-order data
- deduplication and exactly one semantics
- Continuous streaming ingest with many concurrent queries
- streaming data (low latency)
- volatile and "bursty" data
- adding new columns - change schema "on the fly" while streaming data
Try QuestDB, demo and dashboards
The live, public demo is provisioned with the latest QuestDB release and sample datasets:
- Trades: live crypto trades with 30M+ rows per month (OKX exchange)
- FX order book: live charts with orderbook FX pairs.
- Trips: 10 years of NYC taxi trips with 1.6 billion rows
We also have some public, real-time demo dashboards using our Grafana-native plugin:
- Real-time crypto trades: executed trades on OKX from more than 20 assets in real time
- FX order book: live depth/imbalance charts for major FX pairs
QuestDB performance vs. other databases
QuestDB performs very well in performance benchmarks compared to alternatives.
For deep dives into internals and performance, see the following blog posts:
As always, we encourage you to run your own benchmarks.
<div align="center"> <img alt="A chart comparing the ingestion rate of QuestDB, InfluxDB and TimescaleDB." src=".github/readme-benchmark.png" width="600"/> </div>Get started
Use Docker to start quickly:
docker run -p 9000:9000 -p 9009:9009 -p 8812:8812 questdb/questdb
Or macOS users can use Homebrew:
brew install questdb
brew services start questdb
questdb start
questdb stop
Alternatively, to kickoff the full onboarding journey, start with our concise quick start guide.
First-party ingestion clients
QuestDB clients for ingesting data via the InfluxDB Line Protocol:
Connect to QuestDB
Interact with QuestDB and your data via the following interfaces:
- Web Console for an interactive SQL
editor and CSV import on port
9000 - InfluxDB Line Protocol
for streaming ingestion on port
9000 - PostgreSQL Wire Protocol
for programmatic queries on port
8812 - REST API for CSV import and
cURL on port
9000
Popular third-party tools
Popular tools that integrate with QuestDB include:
End-to-end code scaffolds
From streaming ingestion to visualization with Grafana, start with code scaffolds in from our quickstart repository.
Configure QuestDB for production workloads
Find our capacity planning to fine-tune QuestDB for production workloads.
QuestDB Enterprise
For secure operation at greater scale or within larger organizations.
Additional features include:
- high Availablity and read replica(s)
- multi-primary ingestion
- cold storage integration
- role-based access control
- TLS encryption
- native querying of Parquet files via object storage
- support SLAs, enhanced monitoring and more
Visit the Enterprise page for further details and contact information.
Additional resources
📚 Read the docs
- QuestDB documentation: begin the journey
- Product roadmap: check out our plan for upcoming releases
- Tutorials: learn what's possible with QuestDB, step by step
❓ Get support
- Community Discourse forum: join technical discussions, ask questions, and meet other users!
- Public Slack: chat with the QuestDB team and community members
- GitHub issues: report bugs or issues with QuestDB
- Stack Overflow: look for common troubleshooting solutions
🚢 Deploy QuestDB
Contribute
Contributions welcome!
We appreciate:
- source code
- documentation (see our documentation repository)
- bug reports
- feature requests or feedback.
To get started with contributing:
- Have a look through GitHub issues labelled "Good first issue"
- For Hacktoberfest, see the relevant labelled issues
- Read the contribution guide
- For details on building QuestDB, see the [build instructions](https://github.com/questdb/questdb/blob
Related Skills
oracle
339.3kBest practices for using the oracle CLI (prompt + file bundling, engines, sessions, and file attachment patterns).
prose
339.3kOpenProse VM skill pack. Activate on any `prose` command, .prose files, or OpenProse mentions; orchestrates multi-agent workflows.
Command Development
83.9kThis skill should be used when the user asks to "create a slash command", "add a command", "write a custom command", "define command arguments", "use command frontmatter", "organize commands", "create command with file references", "interactive command", "use AskUserQuestion in command", or needs guidance on slash command structure, YAML frontmatter fields, dynamic arguments, bash execution in commands, user interaction patterns, or command development best practices for Claude Code.
Plugin Structure
83.9kThis skill should be used when the user asks to "create a plugin", "scaffold a plugin", "understand plugin structure", "organize plugin components", "set up plugin.json", "use ${CLAUDE_PLUGIN_ROOT}", "add commands/agents/skills/hooks", "configure auto-discovery", or needs guidance on plugin directory layout, manifest configuration, component organization, file naming conventions, or Claude Code plugin architecture best practices.
