Secure 5.1: Couchbase executeQuery

Couchbase executeQuery

Last updated: July 13, 2026

Executes a SQL++ (N1QL) query against the Couchbase cluster, with optional named parameters.

Known limitations:

There is no automatic rollback support. Queries that modify data are permanent.
The keyspace must be fully qualified in the query (e.g., `bucket`.`scope`.`collection`).

Available attributes

You must specify all top-level attributes marked as required. If you specify an optional attribute, you must also specify any nested attributes that it requires.

Attribute	Type	Description	Required
`query`	String	The SQL++ (N1QL) query to execute.	Yes
`params`	Element	Named parameters to bind to the query. Multiple `params` elements can be specified. See nested tags below.	No

Nested tags — params

Attribute	Type	Description	Required
`name`	String	The parameter name, referenced as `$name` in the query.	Yes
`value`	String	The parameter value.	Yes

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.19.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-couchbase-ext.xsd">

    <changeSet id="1" author="liquibase">
        <ext:executeQuery>
            <ext:query>INSERT INTO `myBucket`.myScope.myCollection (KEY, VALUE) VALUES ("id1", {"field": "value"})</ext:query>
        </ext:executeQuery>
        <ext:executeQuery>
            <ext:query>DELETE FROM `myBucket`.myScope.myCollection WHERE META().id = $id</ext:query>
            <ext:params>
                <ext:name>id</ext:name>
                <ext:value>id1</ext:value>
            </ext:params>
        </ext:executeQuery>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "1",
        "author": "liquibase",
        "executeQuery": {
          "query": "DELETE FROM `myBucket`.myScope.myCollection WHERE META().id = $id",
          "params": {
            "name": "id",
            "value": "id1"
          }
        }
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: '1'
      author: liquibase
      executeQuery:
        query: DELETE FROM `myBucket`.myScope.myCollection WHERE META().id = $id
        params:
          name: id
          value: id1

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.19.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-couchbase-ext.xsd">

    <changeSet id="1" author="liquibase">
        <ext:executeQuery>
            <ext:query>INSERT INTO `myBucket`.myScope.myCollection (KEY, VALUE) VALUES ("id1", {"field": "value"})</ext:query>
        </ext:executeQuery>
        <ext:executeQuery>
            <ext:query>DELETE FROM `myBucket`.myScope.myCollection WHERE META().id = $id</ext:query>
            <ext:params>
                <ext:name>id</ext:name>
                <ext:value>id1</ext:value>
            </ext:params>
        </ext:executeQuery>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "1",
        "author": "liquibase",
        "executeQuery": {
          "query": "DELETE FROM `myBucket`.myScope.myCollection WHERE META().id = $id",
          "params": {
            "name": "id",
            "value": "id1"
          }
        }
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: '1'
      author: liquibase
      executeQuery:
        query: DELETE FROM `myBucket`.myScope.myCollection WHERE META().id = $id
        params:
          name: id
          value: id1

Couchbase executeQuery

Available attributes

Nested tags — params

XML example

JSON example

YAML example

More like this