[Feature Request] Add single-record deletion/update methods to DefaultVectorDB

[blinko-space]

Problem Description :

// Need to access private properties turso has security risks
await (defaultVectorDBas any).turso.execute(`DELETE FROM ...`)

The current DefaultVectorDB class lacks methods for single-record operations. Real-world use cases require:

1. Deleting specific vector records by ID

2. Updating record metadata or vectors by ID
   Proposed API additions:

interface DefaultVectorDB {
  deleteById(indexName: string, id: string): Promise<void>;
  updateById(
    indexName: string,
    id: string,
    update: {
      vector?: number[];
      metadata?: Record<string, any>;
    }
  ): Promise<void>;
}

mastra/packages/core/src/vector/libsql/index.ts

Line 12 in 788b45c

export class DefaultVectorDB extends MastraVector {

[abhiaiyer91]

Hi @blinko-space, great idea! We're up for a contribution if you'd like but we can do it otherwise!

[calcsam]

@vishesh-baghel from the Discord said he wanted to work on this one