search legion

Review · Database systems

SingleStore review

A credible fit for mixed transaction and analytics workloads, but hourly compute, separate storage costs and workload trade-offs deserve scrutiny.

6.5/10Search Legion score

We may earn a commission if you buy through links on this page. It never changes a score or a ranking. How we make money

The bottom line

Worth considering for live mixed workloads; price the compute and storage before you migrate.

SingleStore brings transactions, analytics and context into one engine, with an Analyst feature for plain-English questions and a Context Engine that maps schemas and relationships. The homepage also describes millisecond query design and connections to formats such as Apache Iceberg; those are product claims, not a guarantee for every workload.

The Shared plan is free for one workspace, while Standard starts at $0.99/hour and Enterprise at $1.49/hour; storage is billed separately, and monthly or annual plan prices are not published. Reddit discussions are mixed: one commenter reported comparable rather than better performance against PostgreSQL for their use case and cited feature and compatibility trade-offs, while a SingleStore employee said the product is aimed at blended OLTP and OLAP workloads.

Good fit if

  • Teams combining live transactions and analytics
  • Applications querying current business data
  • Evaluating an HTAP database with a free workspace

Skip it if

  • Teams seeking published monthly pricing
  • Workloads needing an open storage format
  • Classic single-machine PostgreSQL applications
SingleStore homepage
SingleStore homepage, captured Nov 7, 2026

ScoresHow it rates

  • Features8
  • Ease of use6
  • Value for money6
  • Support5
  • User sentiment5

What works

  • Combines transactions, analytics and context in one engine
  • Analyst plans queries from plain-English questions
  • Context Engine maps schemas, relationships and definitions
  • Standard includes read replicas and database branching
  • Free Shared workspace includes SQL and programmability features

What doesn't

  • Standard starts at $0.99/hour; monthly price is not published
  • Storage is billed separately
  • Enterprise starts at $1.49/hour
  • A SingleStore employee says its storage format is not open
  • One Reddit user reported feature and compatibility trade-offs

01What SingleStore actually does

SingleStore is a database built to run transactions and analytics on the same system. The pitch is that applications and AI agents can query current business data without moving it first into a separate analytics store. That makes it a candidate for mixed workloads—not an automatic replacement for every database in a stack.

The product also includes Analyst, which plans and runs database queries from plain-English questions, and Context Engine, which maps schemas, relationships, and definitions for users and agents. The homepage says the engine is designed for millisecond query responses; that is a design claim, not a workload-specific guarantee. It also describes connecting operational data to open formats such as Apache Iceberg, plus natural-language analysis.

Pricing is usage-based for cloud compute. The Shared plan is free for one workspace, while Standard starts at $0.99 per hour and Enterprise at $1.49 per hour, according to the pricing page. Storage is billed separately, and no monthly or annual plan price is published.

02Where SingleStore is strong

The clearest case is a workload where fresh operational data needs to support analytics or application queries without a separate reporting pipeline. One engine can reduce the number of systems to coordinate, and the Analyst and Context Engine features are aimed at making that data easier for people and agents to query. Whether that replaces other tools depends on your workload and the features you need.

The pricing page gives teams a way to start small: Shared includes one free workspace, SQL and programmability features, monitoring, and self-support. Standard is aimed at general-purpose production workloads and lists read replicas, database branching, 30-day monitoring, and a 99.9% SLA in one availability zone or 99.99% in two. Enterprise starts at $1.49 per hour and lists online point-in-time recovery, Smart DR, audit logging, and customer-managed encryption keys.

That is a useful set of production options to price against a multi-system setup. A commenter in a Reddit thread described SingleStore’s sweet spot as a blend of transactions and analytics, while cautioning that a classic single-machine application workload may be better served by PostgreSQL. That is a reasonable distinction to test against your own workload before switching.

03Where it falls short

The pricing is not a simple monthly subscription. Standard starts at $0.99 per hour and Enterprise at $1.49 per hour, but the pricing page does not publish monthly or annual totals. Storage is charged separately, with listed examples of $0.023 and $0.025 per GB; optional SingleStore Flow also has separate compute and processing rates. Commitment pricing is available, but its rates are not published. Model compute, storage, and any add-ons against your actual usage before comparing it with your current stack.

The free plan is one shared workspace for evaluation, development, and testing, with self-support; the published pricing details do not list a free trial or additional free-workspace allowance. Don’t assume the hybrid pitch means full feature parity with dedicated databases. In one Reddit discussion, a user reported comparable performance to PostgreSQL on their workload but cited reduced features and compatibility. A SingleStore employee in that thread said regular transactions support READ COMMITTED isolation and SNAPSHOT is used for backup. Another employee acknowledged the storage format is not open. Those are discussion comments, not a substitute for checking current product documentation and migration requirements.

04SingleStore pricing: what you'll actually pay

SingleStore’s Shared plan is free for one workspace, with SQL and programmability features, monitoring, and self-support. It is positioned for evaluation, development, and testing—not as a published-price production plan.

For production, the pricing page lists Standard starting at $0.99 per hour and Enterprise starting at $1.49 per hour. That is a $0.50-per-hour starting-rate gap, but neither tier has a published monthly or annual price. Standard includes read replicas, database branching, 30-day monitoring, and a 99.9% SLA in one availability zone or 99.99% in two. Enterprise adds online point-in-time recovery, Smart DR, audit logging, and customer-managed encryption keys.

Budget separately for storage: examples are $0.023 or $0.025 per GB. Optional SingleStore Flow lists compute at $3.96 per credit and data processing at $0.02 per GB. Commitment pricing is available, but its rates are not published. Price compute, storage, and any add-ons against your workload before comparing the hourly starting rates with a fixed monthly database bill.

Full SingleStore pricing breakdown →

05Switching to (or from) SingleStore

Treat a move to SingleStore as an application and data-model review, not just a database replacement. Its pitch is one engine for transactions, analytics, and context, with SQL and programmability features on the Shared plan. Check that your workload fits that model, and validate how your existing applications and queries use the database. The published material does not detail migration tools, supported source databases, or export procedures, so confirm those with SingleStore before planning a cutover.

Portability deserves the same scrutiny. SingleStore connects operational data to open formats such as Apache Iceberg, but that is not a promise that every workload can move freely between systems. Ask what data can be exported, in what format, and at what cost; those terms are not published here. We also can’t responsibly name reasons people leave based on Reddit: no Reddit posts or comments were included in the published material. For a move away, verify export options and rebuild requirements before committing production workloads.

From the threadsWhat users say

Reddit users are mixed: some say SingleStore can fit workloads that combine transactions and analytics, while others report limited compatibility or prefer separate databases. The comments point to workload-specific evaluation rather than a safe assumption that SingleStore can replace an entire stack.

Feature trade-off
SingleStore had comparable performance to PostgreSQL, with a vast reduction in features and compatibility
r/dataengineering · view thread
Closed storage format
Our storage format is not open
r/dataengineering · view thread
Avoid big-bang moves
I’d avoid a big-bang migration. The real issue is often mixing OLTP and analytics on the same system
r/dataengineering · view thread
Test your workload
A small PoC on the analytics/AI part of your workload is usually the fastest way to see if the performance and complexity trade-offs make sense for you
r/dataengineering · view thread

Questions people ask

What is SingleStore?

SingleStore is an HTAP database: its homepage says it brings transactions, analytics, and context together in one engine. It is designed for applications and AI agents working with current business data, and includes tools for querying data with plain-English questions. The homepage also describes connections to open formats such as Apache Iceberg.

Can SingleStore replace PostgreSQL, SQL Server, or an analytics database?

It is designed to combine transactional and analytical workloads, but that does not make it a universal replacement. One Reddit user reported comparable performance to PostgreSQL on their workload but fewer features and less compatibility. A SingleStore employee said the product’s sweet spot is a blend of OLTP and analytics, not a classic app workload on one machine.

Is SingleStore suitable for high-ingest dashboards and AI workloads?

SingleStore describes itself as built for high ingest, low-latency dashboards, and AI on fresh operational data. That is the company’s positioning, not proof it will fit every workload. In a Reddit discussion about 100GB of daily writes, a company employee recommended a small proof of concept to assess performance and complexity before committing.

How much does SingleStore cost?

According to the pricing page, the Shared plan includes one free workspace for evaluation, development, and testing. Standard starts at $0.99 per hour and Enterprise at $1.49 per hour; neither has a published monthly or annual rate. Storage is billed separately, with examples of $0.023 and $0.025 per GB. Actual costs depend on usage.

What should I check before migrating to SingleStore?

Check feature and compatibility needs, workload shape, storage portability, and transaction requirements before moving. A SingleStore employee on Reddit said its storage format is not open and that regular transactions provide READ COMMITTED isolation; SNAPSHOT is for backup. A commenter also recommended separating OLTP and analytics rather than doing a big-bang migration.

Sources

  1. SingleStore homepage
  2. SingleStore pricing page
  3. Reddit: Experiences with SingleStore - their claims sound too good to be true
  4. Reddit: Planning to migrate to SingleStore worth it?
  5. Reddit: Singlestore interview experience
  6. Reddit: Too Good to be true???? 100 Billion rows in minutes by Altinity and SingleStore?