VectorsDB support for console by premtsd-code · Pull Request #2923 · appwrite/console

premtsd-code · 2026-03-20T16:01:20Z

Summary

Full VectorsDB SDK integration (collections, documents, indexes, CRUD operations)
VectorsDB-specific UI: embedding editor with auto-fold, dimension field, HNSW index types
Route all collection pages through database-type-aware SDK helpers
Fix naming consistency (vectordb → vectorsdb)
Update SDK to 5fe49af with VectorsDB support
Add VectorsDB assets (SVGs, empty states)

Test plan

Create a vectorsdb database and collection
CRUD documents with embeddings
Create/delete HNSW indexes
Verify activity, usage, settings pages work for vectorsdb collections
Verify documentsdb/tablesdb collections still work unchanged

- Route delete/update/index operations through database-type-aware SDK (settings, indexes, activity, usage pages were hardcoding documentsDB) - Add updateEntity, deleteIndex methods to sdk.ts helper - Fix pagination and document loading to use correct SDK for vectorsdb - Fix realtime events to listen for both documentsdb and vectorsdb - Fix embeddings: pass number[] directly instead of JSON.stringify roundtrip - Auto-fold embeddings array in editor on document load

- Add !isVectorsDb guard to useMockSuggestions derivation - Use single sliceString for bracket matching instead of per-char rope traversal

appwrite · 2026-03-20T16:01:25Z

Console (appwrite/console)

Project ID: 688b7bf400350cbd60e9

Sites (1)

Site	Status	Logs	Preview	QR
console-stage `688b7cf6003b1842c9dc`	Ready	View Logs	Preview URL

Tip

Custom domains work with both CNAME for subdomains and NS records for apex domains

coderabbitai · 2026-03-20T16:01:30Z

Important

Review skipped

Auto reviews are disabled on base/target branches other than the default branch.

Please check the settings in the CodeRabbit UI or the .coderabbit.yaml file in this repository. To trigger a single review, invoke the @coderabbitai review command.

⚙️ Run configuration

Configuration used: Organization UI

Review profile: CHILL

Plan: Pro

Run ID: 42b459b2-e413-425b-b30d-307241946751

You can disable this status message by setting the reviews.review_status to false in the CodeRabbit configuration file.

Use the checkbox below for a quick retry:

🔍 Trigger review

✨ Finishing Touches

🧪 Generate unit tests (beta)

Create PR with unit tests
Commit unit tests in branch feat-vectordb

Thanks for using CodeRabbit! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.

❤️ Share

_{Comment @coderabbitai help to get the list of available commands and usage tips.}

greptile-apps · 2026-03-20T16:04:37Z

Greptile Summary

This PR adds full VectorsDB support to the console: SDK integration for collections, documents, and HNSW indexes; a dimension field in the collection-create flow; an embedding editor with auto-fold; and VectorsDB assets/empty states. All five issues flagged in prior rounds (hardcoded embedding URL, missing dimension max, misleading index-type cast in +page.svelte, stale HNSW order: null, and duplicate Import/Export buttons) have been addressed. The remaining findings are non-blocking style and UX polish items.

Confidence Score: 5/5

Safe to merge — all prior blocking issues resolved; remaining findings are P2 style and UX polish.

All five previously flagged P1 issues have been fixed. The three remaining findings are P2: a misleading type cast that has no runtime effect, command-centre labels that use the wrong terminology for VectorsDB/DocumentsDB but remain functional, and a suggestColumns production-path concern that only surfaces when mock AI suggestions are disabled. None block correctness or data integrity.

database-[database]/+layout.svelte (hardcoded labels) and collection-[collection]/+layout.svelte (suggestColumns tableId) warrant a follow-up pass before the feature goes to general availability.

Important Files Changed

Filename	Overview
src/routes/(console)/project-[region]-[project]/databases/database-[database]/(entity)/helpers/sdk.ts	Comprehensive VectorsDB SDK integration — all CRUD operations, index creation/deletion, and entity management correctly dispatch to `baseSdk.vectorsDB` with proper parameter mapping.
src/routes/(console)/project-[region]-[project]/databases/database-[database]/(entity)/helpers/terminology.ts	VectorsDB added to terminology map and DatabaseType union; `toSupportiveIndex` still carries a misleading `as TablesDBIndexType` cast that should be dropped.
src/routes/(console)/project-[region]-[project]/databases/database-[database]/collection-[collection]/indexes/createIndex.svelte	HNSW index types added for VectorsDB; stale `order: null` after switching away from HNSW is correctly reset via `$effect`; auto-fill of embeddings field works as intended.
src/routes/(console)/project-[region]-[project]/databases/database-[database]/collection-[collection]/(components)/editor/embeddingModal.svelte	Now uses `sdk.vectorsDB.createTextEmbeddings` SDK method instead of a hardcoded URL; error handling and state cleanup look correct.
src/routes/(console)/project-[region]-[project]/databases/database-[database]/+layout.svelte	Command-centre entries use hardcoded "Create table" / "Go to tables" labels even though `terminology` is imported — wrong for VectorsDB and DocumentsDB databases.
src/routes/(console)/project-[region]-[project]/databases/database-[database]/collection-[collection]/+layout.svelte	VectorsDB sample-data generation correctly wraps fields in `metadata` and zero-fills embeddings; `suggestColumns` production path passes `tableId` for collection IDs which may fail for VectorsDB in production.

_{Reviews (7): Last reviewed commit: "fix: use collection-specific CreateIndex..." | Re-trigger Greptile}

…preview, metadata defaults

…ordb

…ta label

…ibility

…global override

…onsive resize

…embeddings, Object/HNSW send empty orders

…ordb # Conflicts: # bun.lock # package.json # src/routes/(console)/project-[region]-[project]/databases/database-[database]/(entity)/views/field/activity.svelte # src/routes/(console)/project-[region]-[project]/databases/database-[database]/collection-[collection]/activity/+page.ts

…ordb # Conflicts: # src/routes/(console)/project-[region]-[project]/databases/database-[database]/collection-[collection]/usage/[[period]]/+page.ts

…createIndex

ItzNotABug and others added 7 commits February 11, 2026 17:27

add: vectordb sdk support.

5278437

Merge branch 'feat-documentsdb' into feat-vectordb

db8916d

fix: rename vectordb to vectorsdb for naming consistency.

f38a9bc

fix: guard mock suggestions for vectorsdb, optimize fold scan

218be14

- Add !isVectorsDb guard to useMockSuggestions derivation - Use single sliceString for bracket matching instead of per-char rope traversal

vectorsdb collection page and empty state bugs

5d0e4ff

merge feat-documentsdb and fix SDK type errors

a1ec42b

greptile-apps bot reviewed Mar 20, 2026

View reviewed changes

premtsd-code added 13 commits March 21, 2026 15:12

(fix): vectorsdb review fixes — index creation, SDK embeddings, fold …

1bfe064

…preview, metadata defaults

(chore): update console SDK to 04899af with rebuilt types

8accb15

Merge remote-tracking branch 'origin/feat-documentsdb' into feat-vect…

6df70db

…ordb

Merge remote-tracking branch 'origin/feat-documentsdb' into feat-vect…

d89fad8

…ordb

(fix): import Columns type from correct module in sheetOptions

b259318

(fix): remove databaseType param from suggestColumns call

d735f7f

(chore): update console SDK to 2291c59 with rebuilt dist

51b499a

Merge remote-tracking branch 'origin/feat-documentsdb' into feat-vect…

8c29b65

…ordb

(fix): embedding fold preview with inline values, vectorsdb sample da…

2a5aa4d

…ta label

add vectorsdb document-level activity logs

3482580

feat: update SDK to pkg.vc preview with vectorsdb DatabaseType enum

6eef1c0

fix: remove misleading DocumentsDBIndexType cast for vectorsdb compat…

995af51

…ibility

merge: feat-documentsdb into feat-vectordb

902ea0a

HarshMN2345 reviewed Mar 25, 2026

View reviewed changes

Comment thread ...oject]/databases/database-[database]/collection-[collection]/(components)/editor/view.svelte Outdated

HarshMN2345 reviewed Mar 25, 2026

View reviewed changes

Comment thread ...oject]/databases/database-[database]/collection-[collection]/(components)/editor/view.svelte Outdated

Merge feat-documentsdb into feat-vectordb

fecbdaf

HarshMN2345 reviewed Mar 25, 2026

View reviewed changes

Comment thread ...)/project-[region]-[project]/databases/database-[database]/table-[table]/sheetOptions.svelte Outdated

HarshMN2345 requested changes Mar 25, 2026

View reviewed changes

address review: requestMeasure for folding, shared HintBadge, remove …

c85040c

…global override

premtsd-code added 10 commits March 25, 2026 22:00

embeddings fold: native gutter chevron, truncated value preview, resp…

47a660c

…onsive resize

fix: override picomatch to 4.0.4 for ReDoS vulnerability

462177c

add JSON import/export UI for documentsdb and vectorsdb collections

5860ca1

merge feat-documentsdb into feat-vectordb

88bfd27

merge feat-documentsdb into feat-vectordb

db01d28

vectorsdb create index: dynamic form per index type, HNSW auto-fills …

8f5aa4a

…embeddings, Object/HNSW send empty orders

merge: feat-documentsdb into feat-vectordb, update SDK to d27fbd5

fdcb779

merge: resolve conflicts with remote feat-vectordb

1d9e737

Merge remote-tracking branch 'origin/feat-documentsdb' into feat-vect…

83b7668

…ordb # Conflicts: # src/routes/(console)/project-[region]-[project]/databases/database-[database]/collection-[collection]/usage/[[period]]/+page.ts

greptile-apps bot reviewed Apr 16, 2026

View reviewed changes

Comment thread ...]-[project]/databases/database-[database]/collection-[collection]/indexes/createIndex.svelte

feat: gate multi-db UI behind multi-db flag, fix stale HNSW order in …

13181ee

…createIndex

greptile-apps bot reviewed Apr 17, 2026

View reviewed changes

Comment thread ...roject-[region]-[project]/databases/database-[database]/collection-[collection]/+page.svelte Outdated

premtsd-code added 2 commits April 17, 2026 07:34

fix: remove duplicate Import/Export JSON buttons

881027a

fix: use collection-specific CreateIndex in layout sheet to support HNSW

23b200c

HarshMN2345 approved these changes Apr 17, 2026

View reviewed changes

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

VectorsDB support for console#2923

VectorsDB support for console#2923
premtsd-code wants to merge 35 commits intofeat-documentsdbfrom
feat-vectordb

premtsd-code commented Mar 20, 2026

Uh oh!

appwrite bot commented Mar 20, 2026 •

edited

Loading

Uh oh!

coderabbitai bot commented Mar 20, 2026 •

edited

Loading

Review skipped

Uh oh!

greptile-apps bot commented Mar 20, 2026 •

edited

Loading

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

3 participants

Conversation

premtsd-code commented Mar 20, 2026

Summary

Test plan

Uh oh!

appwrite bot commented Mar 20, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Console (appwrite/console)

Uh oh!

coderabbitai bot commented Mar 20, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Review skipped

Uh oh!

greptile-apps bot commented Mar 20, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Greptile Summary

Confidence Score: 5/5

Important Files Changed

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

3 participants

appwrite bot commented Mar 20, 2026 •

edited

Loading

coderabbitai bot commented Mar 20, 2026 •

edited

Loading

greptile-apps bot commented Mar 20, 2026 •

edited

Loading