Key features

Universal data types

Full structured data support for analytics and transactions, including a wide range of string, number, date, time, and binary types, available in both columnstore and rowstore tables.

Native JSON and BSON

Advanced semistructured data type handling using JSON and BSON types, along with high-speed analytics on these types.

Vector embeddings in SQL

SingleStore’s VECTOR type simplifies AI/vector apps with embeddings, supports ANN, and provides infix operators <*> (dot product) and <-> (Euclidean) for similarity search.

How it works

Universal data types

Universal data types

Store structured, JSON, BSON, spatial, vector, text and time-series data.

Resilience and flexibility

Resilience and flexibility

Update all data transactionally with high availability on a scale-out architecture, and access structured and semistructured data through SQL and the MongoDB-compatible Kai interface.

Full SQL power

Full SQL power

Apply filters, joins, aggregates, subqueries, CTEs, window functions, and more across both structured and advanced types.

Key benefits

All in one place

Simpler development since all major types can be stored in a single data platform.

Lower costs

A single system can handle all types; it's not necessary to run multiple data management systems and move data between them.

Fast analytics

Achieve speedups of nearly 1000x on semistructured (JSON/BSON) analytics compared to pure NoSQL.