Query

database.sqlite — instance_ai_mcp_regis...

SQL

CREATE TABLE "instance_ai_mcp_registry_connections"  (
  "id" varchar PRIMARY KEY NOT NULL,
  "credentialId" varchar(36) NOT NULL,
  "serverSlug" varchar(255) NOT NULL,
  "toolFilter" text,
  "userId" varchar NOT NULL,
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  CONSTRAINT "FK_1e826120e7e53ebc4681f026de8" FOREIGN KEY ("credentialId") REFERENCES "credentials_entity" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_1d25707354d2012da256eb2ec0a" FOREIGN KEY ("serverSlug") REFERENCES "mcp_registry_server" ("slug") ON DELETE CASCADE,
  CONSTRAINT "FK_8b42c08a531d76410980c639a5b" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar ✓ Rename | Drop
credentialId varchar(36) Rename | Drop
serverSlug varchar(255) Rename | Drop
toolFilter TEXT ✓ Rename | Drop
userId varchar Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
userId user.id
serverSlug mcp_registry_server.slug
credentialId credentials_entity.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_16db3adb7b19df1ee55ff06b27
  • userId
  • serverSlug
  • credentialId
 ✓ SQL 
CREATE UNIQUE INDEX "IDX_16db3adb7b19df1ee55ff06b27"
ON "instance_ai_mcp_registry_connections" ("userId", "serverSlug", "credentialId")
Drop
sqlite_autoindex_instance_ai_mcp_registry_connections_1 id ✓ SQL
-- no sql found --
 Drop