paperclipai/paperclip · error · Error

Destructive plugin migrations are not allowed in Phase 1

Error message

Destructive plugin migrations are not allowed in Phase 1

What it means

Phase-1 migration policy guard in validatePluginMigrationStatement: the statement begins with DROP or TRUNCATE. Plugin migrations may create and evolve their own namespace objects but may never destroy data or structures; the destructive migration file is at fault.

Source

Thrown at server/src/services/plugin-database.ts:200

    /\bdo\s+(?:\$\$|language\b)/,
  ];
  const matched = banned.find((pattern) => pattern.test(normalized));
  if (matched) {
    throw new Error(`Plugin SQL contains a disallowed statement or clause: ${matched.source}`);
  }
}

export function validatePluginMigrationStatement(
  statement: string,
  namespace: string,
  coreReadTables: readonly PluginDatabaseCoreReadTable[] = [],
): void {
  assertIdentifier(namespace, "namespace");
  assertNoBannedSql(statement);

  const normalized = normaliseSql(statement);
  if (/^\s*(drop|truncate)\b/.test(normalized)) {
    throw new Error("Destructive plugin migrations are not allowed in Phase 1");
  }

  if (/\bdelete\s+from\b/.test(normalized)) {
    throw new Error("Plugin migrations cannot delete data");
  }

  const ddlOrBackfillAllowed =
    /^(create|alter|comment)\b/.test(normalized) ||
    /^(insert\s+into|update)\b/.test(normalized) ||
    (normalized.startsWith("with ") && /\b(insert\s+into|update)\b/.test(normalized));
  if (!ddlOrBackfillAllowed) {
    throw new Error("Plugin migrations may contain DDL or namespace-scoped backfill statements only");
  }

  const refs = extractQualifiedRefs(statement);
  if (refs.length === 0 && !normalized.startsWith("comment ")) {
    throw new Error("Plugin migration objects must use fully qualified schema names");
  }

View on GitHub (pinned to 120ae5428f)

Solutions

1. Remove destructive operations (DROP, TRUNCATE, etc.) from plugin migrations; they are not allowed in Phase 1.

When it happens

Trigger: Thrown at server/src/services/plugin-database.ts:200 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of paperclipai/paperclip@120ae5428f (2026-08-18). Data as JSON: /api/errors/b362d8bfcf109099. Report an issue: GitHub.