Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
// @vitest-environment node
import { describe, expect, test } from "vitest";
import { buildSystemPrompt } from "./prompt";
describe("buildSystemPrompt", () => {
test("inspects the live page only for page-dependent requests", () => {
const prompt = buildSystemPrompt({
path: "/landing",
title: "Workspace",
context: "workspaces/default",
});
expect(prompt).toContain(
"Call get_page_state when the request depends on the live page"
);
expect(prompt).toContain(
"skip it for self-contained questions or casual conversation"
);
expect(prompt).not.toContain("Always call get_page_state first");
});
test("omits project-only workflow details from workspace chats", () => {
const prompt = buildSystemPrompt({
path: "/projects/other",
title: "Other project",
context: "workspaces/default",
});
expect(prompt).toContain(
"call get_workspace_overview before recommending a next step"
);
expect(prompt).not.toContain("When get_project_overview confirms");
expect(prompt).not.toContain("In a project-bound chat");
expect(prompt).not.toContain("A historical failed Task Run");
});
test("uses the bounded instance overview for instance sync questions", () => {
const prompt = buildSystemPrompt({
path: "/instances/primary",
title: "Primary instance",
context: "workspaces/default",
instanceName: "instances/primary",
runMode: "read-only",
});
expect(prompt).toContain("call get_instance_overview");
expect(prompt).toContain("reads one page");
expect(prompt).toContain("visible to the member");
expect(prompt).toContain(
"never claim there are no out-of-sync databases across the entire instance"
);
});
test("keeps project guidance when the selected project differs from the workspace chat", () => {
const prompt = buildSystemPrompt({
path: "/landing",
title: "Workspace",
context: "workspaces/default",
referencedProject: "projects/orders",
});
expect(prompt).toContain("When get_project_overview confirms");
expect(prompt).toContain(
"call get_project_governance_overview before describing"
);
expect(prompt).not.toContain(
"In a workspace-bound chat, call get_workspace_overview"
);
});
test("does not repeat count workflows for a selected project", () => {
const prompt = buildSystemPrompt({
path: "/landing",
title: "Workspace",
context: "workspaces/default",
referencedProject: "projects/orders",
});
expect(prompt.match(/precise instance filter/g)).toHaveLength(1);
});
test.each([
{ runMode: "read-only" as const },
{ referencedProject: "projects/orders" },
])("omits page-action workflows for restricted turns: %j", (restriction) => {
const prompt = buildSystemPrompt({
path: "/projects/orders",
title: "Orders",
context: "projects/orders",
...restriction,
});
expect(prompt).not.toContain("Confirm destructive DOM actions");
expect(prompt).not.toContain("DOM interaction workflow");
expect(prompt).not.toContain("DOM-first");
expect(prompt).not.toContain("navigate(list=true");
expect(prompt).toContain("2-3 distinct, contextual Continue questions");
});
test("requires fresh DOM inspection before interacting with the page", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders",
title: "Orders",
context: "projects/orders",
});
expect(prompt).toContain(
'Before interacting with the page, call get_page_state(mode="dom") for fresh element refs'
);
expect(prompt).toContain("Confirm destructive DOM actions");
});
test("requests useful English follow-up questions that send on click", () => {
const prompt = buildSystemPrompt({ path: "/landing", title: "Workspace" });
expect(prompt).toContain(
"one primary action: Open, draft-plan, or draft-issue-comment"
);
expect(prompt).toContain("current-turn overview evidence");
expect(prompt).toContain("2-3 distinct, contextual Continue questions");
expect(prompt).toContain("For a successful answer");
expect(prompt).toContain("English");
expect(prompt).toContain("Do not add filler questions");
expect(prompt).toContain("sends it as a new user message");
expect(prompt).toContain("does not itself approve or execute a change");
});
test("offers only evidenced exact Issue links without taking a review action", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders/issues/123",
title: "Issue",
context: "projects/orders",
referencedProject: "projects/orders",
referencedIssue: "projects/orders/issues/123",
});
expect(prompt).toContain("open-issue");
expect(prompt).toContain("review-issue-plan");
expect(prompt).toContain("view-failed-task");
expect(prompt).toContain("current failed Task");
expect(prompt).toContain("never approves, retries, or executes");
});
test("uses empty-project setup evidence in the same priority as Project Home", () => {
const prompt = buildSystemPrompt({
path: "/projects/sample",
title: "Sample",
context: "projects/sample",
});
expect(prompt).toContain("transfer an eligible unassigned database first");
expect(prompt).toContain("connect an instance directly");
expect(prompt).toContain("create a database on an available instance");
expect(prompt).toContain("transfer-project-databases");
expect(prompt).toContain("specific setup request in any active project");
});
test("requests fresh validation only for database choices", () => {
const prompt = buildSystemPrompt({ path: "/landing", title: "Workspace" });
expect(prompt).toContain("resourceKind");
expect(prompt).toContain("canonical option values");
expect(prompt).toContain("Ask which Project first");
expect(prompt).not.toContain('resourceKind="environment"');
});
test("requires a failed completion when an API request is rejected", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders/issues",
title: "Issues",
context: "projects/orders",
});
expect(prompt).toContain(
"If call_api returns an error or HTTP status 400 or higher"
);
expect(prompt).toContain("done({ text, success: false, actions: [] })");
expect(prompt).toContain("Do not claim the query or change succeeded");
expect(prompt).toContain("Query result contains permissionDenied");
});
test("uses a selected project for one turn without narrowing normal API calls", () => {
const prompt = buildSystemPrompt({
path: "/projects/original",
title: "Original project",
context: "projects/original",
referencedProject: "projects/referenced",
runMode: "read-only",
});
expect(prompt).toContain("Chat context: projects/original");
expect(prompt).toContain(
"Referenced project for this turn: projects/referenced"
);
expect(prompt).toContain(
"bounded project tools target the referenced project"
);
expect(prompt).toContain("This is not a chat context change");
expect(prompt).toContain("matching the referenced project");
expect(prompt).toContain("search_api");
expect(prompt).toContain("call_api");
expect(prompt).toContain("existing permissions and may change data");
expect(prompt).toContain("only make changes when the user explicitly asks");
expect(prompt).not.toContain("Do not navigate, call APIs");
expect(prompt).not.toContain("Either works for mutations");
});
test("uses a selected database in its owning project for only this turn", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders",
title: "Orders",
context: "projects/orders",
referencedProject: "projects/billing",
referencedDatabase: "instances/prod/databases/billing",
runMode: "read-only",
});
expect(prompt).toContain(
"Selected database for this turn: instances/prod/databases/billing"
);
expect(prompt).toContain("owning project must match projects/billing");
expect(prompt).toContain("fresh get_database_overview result");
expect(prompt).toContain("does not change the chat context");
expect(prompt).toContain(
"only make changes when the member explicitly asks"
);
expect(prompt).toContain("search_api");
expect(prompt).toContain("call_api");
expect(prompt).toContain(
'use get_database_count with scope "referenced-instance"'
);
expect(prompt).toContain(
"A workspace instance may span projects; a project instance remains in its owning project"
);
expect(prompt).toContain(
"For filtered counts in a Workspace or Project, use search_api and call_api SearchDatabases with a project filter for Project scope"
);
expect(prompt).toContain("inspect one page");
expect(prompt).toContain(
'If partial is true, say "at least N" rather than claiming an exact total'
);
expect(prompt).not.toContain("Referenced project for this turn");
});
test("grounds a selected Plan in a fresh overview for only this turn", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders/plans",
title: "Plans",
context: "projects/orders",
referencedProject: "projects/billing",
referencedPlan: "projects/billing/plans/7",
runMode: "read-only",
});
expect(prompt).toContain(
"Selected Plan for this turn: projects/billing/plans/7"
);
expect(prompt).toContain("fresh get_plan_overview result");
expect(prompt).toContain("owning project must match projects/billing");
expect(prompt).toContain("does not include Sheet or Release SQL");
expect(prompt).toContain("corresponding Sheet or Release read API");
expect(prompt).toContain("does not change the chat context");
expect(prompt).toContain(
"only make changes when the member explicitly asks"
);
expect(prompt).not.toContain("Referenced project for this turn");
});
test("offers an unsaved Plan draft only for generated DDL grounded in this turn's selected database", () => {
const selectedPrompt = buildSystemPrompt({
path: "/projects/orders",
title: "Orders",
context: "projects/orders",
referencedProject: "projects/billing",
referencedDatabase: "instances/prod/databases/billing",
});
const unselectedPrompt = buildSystemPrompt({
path: "/projects/orders",
title: "Orders",
context: "projects/orders",
});
expect(selectedPrompt).toContain("draft-plan");
expect(selectedPrompt).toContain('"create a table"');
expect(selectedPrompt).toContain("DatabaseService/GetDatabaseSchema");
expect(selectedPrompt).toContain("instances/prod/databases/billing/schema");
expect(selectedPrompt).toContain("generated DDL");
expect(selectedPrompt).toContain("exactly one fenced `sql` code block");
expect(selectedPrompt).toContain("opens a populated, unsaved Plan");
expect(selectedPrompt).toContain("never persists or executes SQL");
expect(selectedPrompt).toContain(
"one primary action: Open, draft-plan, or draft-issue-comment"
);
expect(unselectedPrompt).not.toContain("generated DDL");
});
test("grounds a selected issue and its approval consequence in fresh state", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders",
title: "Orders",
context: "projects/orders",
referencedProject: "projects/billing",
referencedIssue: "projects/billing/issues/42",
runMode: "read-only",
});
expect(prompt).toContain(
"Selected Issue for this turn: projects/billing/issues/42"
);
expect(prompt).toContain("fresh get_issue_overview result");
expect(prompt).toContain("does not change the chat context");
expect(prompt).toContain("IssueService/ApproveIssue");
expect(prompt).toContain("IssueService/RejectIssue");
expect(prompt).toContain("may queue rollout creation");
expect(prompt).toContain("does not mean tasks have executed");
expect(prompt).toContain("may immediately grant access or a project role");
expect(prompt).toContain(
"After an approved decision request, re-read the Issue"
);
expect(prompt).not.toContain("Referenced project for this turn");
});
test("offers only a reviewed and unsent Issue comment draft", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders/issues/42",
title: "Issue",
context: "projects/orders",
referencedProject: "projects/orders",
referencedIssue: "projects/orders/issues/42",
});
expect(prompt).toContain("security review of an Issue");
expect(prompt).toContain("draft-issue-comment");
expect(prompt).toContain("exact observed Issue name");
expect(prompt).toContain("unsent editor draft");
expect(prompt).toContain("Do not include speculative findings");
});
test("names the chat context separately from the live page", () => {
const prompt = buildSystemPrompt({
path: "/projects/other/issues",
title: "Other project",
context: "projects/orders",
});
expect(prompt).toContain("Chat context: projects/orders");
expect(prompt).toContain("Current page: /projects/other/issues");
expect(prompt).toContain("Navigation does not change the chat context");
});
test("accepts a workspace resource as the chat context", () => {
expect(
buildSystemPrompt({
path: "/landing",
title: "Workspace",
context: "workspaces/demo",
})
).toContain("Chat context: workspaces/demo");
});
test("does not carry a past project reference into an unqualified workspace follow-up", () => {
const prompt = buildSystemPrompt({
path: "/landing",
title: "Workspace",
context: "workspaces/demo",
});
expect(prompt).toContain(
"A selected resource in an earlier user message does not scope this turn"
);
expect(prompt).toContain(
"Do not infer a project from prior conversation when the current message has no project reference or explicit project name"
);
expect(prompt).toContain(
"For an unqualified list or count in a workspace-bound chat, use the whole chat workspace"
);
expect(prompt).toContain(
"For an unfiltered active-database count in the chat Workspace or Project, or the referenced Project for this turn, use get_database_count with its default scope"
);
expect(prompt).toContain(
"For filtered counts in a Workspace or Project, use search_api and call_api SearchDatabases"
);
expect(prompt).toContain(
"For other instance scopes, use search_api and call_api SearchDatabases with the precise instance filter"
);
expect(prompt).toContain(
"ask which project only when the member requests a project-specific result without identifying one"
);
expect(prompt).toContain(
'If partial is true, say "at least N" rather than claiming an exact total'
);
expect(prompt).toContain(
"Do not automatically follow pagination tokens to count all resources"
);
expect(prompt).not.toContain("follow every page");
expect(prompt).not.toContain(
"if it is a workspace and the request requires a specific project, ask which project"
);
});
test("uses a compact count for both chat-bound and referenced projects", () => {
const projectPrompt = buildSystemPrompt({
path: "/projects/orders",
title: "Orders",
context: "projects/orders",
});
const referencePrompt = buildSystemPrompt({
path: "/landing",
title: "Workspace",
context: "workspaces/demo",
referencedProject: "projects/orders",
});
expect(projectPrompt).toContain(
"For an unfiltered active-database count in the chat Workspace or Project, or the referenced Project for this turn, use get_database_count with its default scope"
);
expect(referencePrompt).toContain(
"For an unfiltered active-database count in the chat Workspace or Project, or the referenced Project for this turn, use get_database_count with its default scope"
);
expect(referencePrompt).toContain("referenced Project for this turn");
expect(referencePrompt).toContain(
"For filtered counts in a Workspace or Project, use search_api and call_api SearchDatabases with a project filter for Project scope"
);
});
test("teaches the ref-based DOM workflow", () => {
const prompt = buildSystemPrompt({
path: "/issues/123",
title: "Issue 123",
role: "DBA",
});
expect(prompt).toContain(
'DOM interaction workflow: get_page_state(mode="dom") → read element refs like [e1] in the DOM tree → dom_action(type, ref, value).'
);
expect(prompt).not.toContain("read element indices");
expect(prompt).not.toContain("dom_action(type, index, value)");
});
test("keeps a read-only landing starter on its current page", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders",
title: "Order service",
context: "projects/orders",
runMode: "read-only",
});
expect(prompt).toContain("Stay on the current page");
expect(prompt).toContain("Do not navigate");
expect(prompt).toContain("Do not navigate, call APIs");
expect(prompt).toContain("get_project_open_issues");
expect(prompt).toContain("get_project_overview");
expect(prompt).toContain("get_project_governance_overview");
expect(prompt).toContain("get_issue_overview");
expect(prompt).toContain("get_database_overview");
expect(prompt).toContain("get_project_recent_activity");
expect(prompt).toContain("get_workspace_recent_activity");
});
test("asks the Agent to use a project overview for a current-state question", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders",
title: "Order service",
context: "projects/orders",
runMode: "read-only",
});
expect(prompt).toContain(
"call get_project_overview before recommending a next step"
);
expect(prompt).toContain(
"answer the member's actual question directly, not with a catalog of capabilities"
);
expect(prompt).toContain(
"recommend at most one next step when the available evidence supports it"
);
expect(prompt).not.toContain("<project_readiness_evidence>");
});
test.each([
["project", "projects/orders"],
["workspace", "workspaces/default"],
])("requires complete %s facets before claiming absence", (_, context) => {
const prompt = buildSystemPrompt({
path: "/landing",
title: "Home",
context,
});
expect(prompt).toContain(
"Do not claim a resource or issue is absent unless its facet is available, partial is false, and it is empty"
);
expect(prompt).toContain(
"A partial or unavailable facet cannot establish absence"
);
});
test("asks the Agent to inspect project governance before describing it", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders",
title: "Order service",
context: "projects/orders",
runMode: "read-only",
});
expect(prompt).toContain(
"call get_project_governance_overview before describing how Database Changes are reviewed"
);
expect(prompt).toContain("conditions are evaluated per Database Change");
});
test("asks the Agent to inspect a selected Issue before describing its state", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders",
title: "Order service",
context: "projects/orders",
runMode: "read-only",
});
expect(prompt).toContain(
"call get_issue_overview before explaining a specific Issue's approval"
);
expect(prompt).toContain(
"not_started for a review run means no run is recorded; it does not prove that review is configured or applicable"
);
expect(prompt).toContain("matching the chat project");
});
test("asks the Agent to inspect a selected database before describing its state", () => {
const prompt = buildSystemPrompt({
path: "/projects/orders",
title: "Order service",
context: "projects/orders",
runMode: "read-only",
});
expect(prompt).toContain(
"call get_database_overview before explaining a specific database's current state"
);
expect(prompt).toContain("DML prior-backup readiness");
expect(prompt).toContain(
"does not establish that an existing recoverable backup exists"
);
});
test("asks the Agent to use a workspace overview without recent activity", () => {
const prompt = buildSystemPrompt({
path: "/landing",
title: "Workspace",
context: "workspaces/default",
runMode: "read-only",
});
expect(prompt).toContain(
"call get_workspace_overview before recommending a next step"
);
expect(prompt).toContain(
"Use get_workspace_recent_activity only when the member asks what changed recently"
);
});
});