Querying in Couchbase - N1QL

Now available in Developer Preview 3!

Welcome to the N1QL (pronounced "Nickel") corner! We're excited to introduce N1QL - our next generation query language. N1QL presents easy and familiar abstractions to quickly develop scalable applications that work with next generation database systems. It allows for joins, filter expressions, aggregate expressions and many other features to build a rich application. Go ahead and give N1QL a spin today by trying out the online tutorial or downloading N1QL for Couchbase Server.

N1QL Developer Preview - Online Tutorial

Try it now

N1QL Developer Preview - Downloads

Operating System

N1QL

Community Edition - Developer Preview

64-bit Linux

32-bit Linux

64-bit Windows

32-bit Windows

64-bit Mac OS X

Operating System

N1QL

Community Edition - Developer Preview

64-bit Linux

32-bit Linux

64-bit Windows

32-bit Windows

64-bit Mac OS X


Going beyond the download - Instructions

Step 1. Expand the package archive
Step 2. Run ./start_tutorial.sh (On Windows start_tutorial.bat)
Step 3. Open http://localhost:8093/tutorial in your browser
 
To connect to a Couchbase Server 
./cbq-engine -couchbase http://<couchbase-server-name>:8091/
 
To use the command-line interactive query tool
./cbq -engine=http://<couchbase-query-engine-server-name>:8093/


Getting Started with Couchbase on N1QL

Latest N1QL Questions

fredericb's picture
Asked 9 hours 30 min ago
Latest activity 5 hours 27 min ago

How to write Where condition on arrays using INDEX

While trying the N1QL language, I found a difficulty to request the following:

Let say the document contains, among other attributes, an array of values as in
varArray : [ val1, val2, val3 ]

How can I...

fredericb's picture
Asked 9 hours 40 min ago
Latest activity 5 hours 25 min ago

How to partially update a document

Many times, it is very convenient to only update one attribute instead of loading everything into memory and then pushing everything onto the wire, specially when a few changed (let say only 1% had changed).

I did not find any element, except an issue opened from 2012/06 (...

Latest Community Blogs

Shopper or Merchant? Check-out N1QL Querying

N1QL is a next generation query language for Couchbase Server. It goes beyond SQL and the...
Tags:   N1QL

Announcing Couchbase Query Language (N1QL) - Developer Preview 2!

I am very excited to announce the latest Developer Preview release of the Couchbase Query Language...

N1QL - It Makes Cents!

*Ba Dum Tschhh* …See what I did there? Makes cents? Get it? Haha. So… N1QL (pronounced Nickel)…...