基于Couchbase Server 4.6.4，能否通过REST API创建N1QL主索引？

Absolutely! You can definitely automate creating a N1QL primary index on Couchbase Server 4.6.4 using the REST API — the web console you used earlier is just a frontend that calls these same APIs under the hood. Here's a straightforward breakdown of how to implement this:

Step 1: Identify the N1QL Query API Endpoint #

Couchbase's Query Service exposes a REST endpoint at:
http://<your-couchbase-server-ip>:8093/query/service
Port 8093 is the default for the N1QL Query Service, so make sure this service is enabled on your cluster.

Step 2: Construct the POST Request #

You'll send a POST request with a JSON body containing your CREATE PRIMARY INDEX statement. This is the exact same query the web console runs when you create a primary index manually.

Example with curl #

Here's a ready-to-use curl command you can adapt for your environment:

curl -X POST -u <admin-username>:<admin-password> -H "Content-Type: application/json" \
http://localhost:8093/query/service \
-d '{
  "statement": "CREATE PRIMARY INDEX ON `your-bucket-name` USING GSI;"
}'

Key Notes: #

• Replace <admin-username>:<admin-password> with your actual Couchbase cluster credentials (needs permissions to manage indexes on the target bucket).
• Replace your-bucket-name with the name of the bucket where you want to create the primary index (wrap it in backticks if the name contains special characters).
• If you want to specify a custom index name instead of the default #primary, modify the statement like this:

  CREATE PRIMARY INDEX custom_primary_idx ON `your-bucket-name` USING GSI;
  

Step 3: Verify the Response #

A successful request will return a JSON response with "status": "success":

{"requestID":"<uuid>","signature":{},"results":[],"status":"success","metrics":{"elapsedTime":"5.123ms","executionTime":"4.987ms","resultCount":0,"resultSize":0}}

If there's an error (e.g., invalid credentials, bucket doesn't exist, index already exists), the response will include a "status": "error" field with details to help troubleshoot.

Why This Works #

The Couchbase web console relies entirely on the cluster's REST APIs to perform administrative tasks like creating indexes. By directly calling these APIs, you can fully automate your cluster configuration workflows — perfect for CI/CD pipelines or infrastructure-as-code setups.

内容的提问来源于stack exchange，提问作者Humberto Corrêa