Use powerful SQL with Couchbase
SQL++ is SQL for JSON with industry-standard ANSI syntax. SQL++ supports common concepts like ACID transactions, hierarchical schema called scopes, and joins across documents. It also takes advantage of our patented cost-based optimization. Take the tutorial to learn more.
Use SQL++ to overcome tough query challenges
Cost-efficient
Changing queries to a new language is costly. SQL++ meets ANSI 92 standards, which makes migration to Couchbase faster and easier.
Fast
Writing queries can be complex and lead to slow speeds if executed incorrectly. Our cost-based optimizer (CBO) ensures the best performance.
Consistent
Using multiple databases for an application leads to data inconsistency. Couchbase can support all your use cases with a single multi-model database.
Familiar
Learning a new proprietary query language for a database is challenging. SQL++ allows developers to use their existing SQL skills for JSON.
SQL++ key capabilities
SQL++ provides teams with powerful ways to interact with data and develop faster queries to support critical applications.
Global Secondary Indexes (GSI)
GSIs enable low-latency queries for interactive applications. They support collection-level processing.
Indexing innovations
Couchbase includes composite and array indexes and a function that identifies the best index for SQL++ queries.
SQL++: SQL-like queries with the flexibility of JSON
Develop engaging applications with ease using a comprehensive and declarative JSON query language. Developers can rapidly adapt to changing business requirements using a schemaless JSON document store.

Query without compromise, with capabilities you expect from SQL queries
SQL++ is a high-performance NoSQL query language with built-in optimizers and indexer enablers to support millions of concurrent interactions with sub-millisecond latencies. Couchbase’s multi-dimensional architecture uses SQL++ across its query, index, search, and analytics services, partitioning to elastically scale data capacity and deliver accelerated query performance.

Familiar tooling makes query development and optimization a breeze
SQL++ is accessed through the Query Workbench and has a built-in index advice feature that tells the developer what indexes are needed to optimize their query. Flex Index uses the inverted search index from the Full-Text Search Service for complicated query predicates. Couchbase also includes a cost-based optimizer and JavaScript-based user-defined functions to manipulate the resulting data.
