Query Workbench Installation - N1QL - SQL type queries

Query Workbench is when you want a SSMS / mysql client kinda interface.

• Enables you to write queries like SQL queries. 
• These queries are called N1QL queries pronounced as Nickel Queries

Download : 

http://developer.couchbase.com/documentation/server/4.0/developer-guide/query-workbench-intro.html

• Extract
• Run the "Launch ..." bat file.
• Command Window will popup saying Launching UI server, to use, point browser at 
• http://localhost:8094Hit enter to stop server:
• From Browser go to the address mentioned

Once you are done:

you can run SQL like queries ,

NOTE: if you are not able to see anything in Queryable Buckets on the left side then 

Type 

CREATE INDEX `beer-sample-type-index` ON `beer-sample`(type) USING GSI;

or

CREATE INDEX id_ix on `beer-sample`(meta().id);

more on Indexes http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/createindex.html

These are diff types of indexes being set on beer-sample DB.

Also the DB name should be enclosed in BACK TICK and not single inverted commas

Sample N1QL queries: 

https://gist.github.com/martinesmann/6eb50d033436decdfe3c#file-n1ql_samples-sql