Edit

Use IntelliSense and auto-completion in the Azure Cosmos DB query editor (preview)

  • Applies to: ✅ NoSQL

What this feature does

This preview capability helps accelerate query authoring with contextual completions.

Prerequisites

  • Azure Databases extension preview build.
  • Connected Azure Cosmos DB account and container.
  • Query editor opened on a target container.

Trigger completions

  1. Open the query editor.
  2. Start typing a query, for example:
SELECT c.
FROM c
WHERE c.
  1. Use completion suggestions to insert field names and query tokens.

Example authoring flow

SELECT c.id, c.status, c.updatedAt
FROM c
WHERE c.status = "active"
ORDER BY c.updatedAt DESC

Use completions while building projection, filter, and sort clauses.

Troubleshooting

  • If no suggestions appear, confirm you are in a query editor for a connected container.
  • If fields are missing, run a baseline query first so schema context can be refreshed.
  • If behavior is inconsistent, reload Visual Studio Code and reopen the container query editor.

Limitations

  • Suggestions can be partial for highly dynamic or sparse document structures.
  • Complex expressions can still require manual SQL authoring.
  • Last updated on