[Bug]: After creating an Agent in the SQL Editor, the Agent is not displayed in the "Chat with your data" interface

[liyulin0722-dominic]

Short description of current behavior

After creating an Agent in the SQL Editor, the Agent is not displayed in the "Chat with your data" interface

Video or screenshots

No response

Expected behavior

No response

How to reproduce the error

No response

Anything else?

No response

[Muitamax]

To debug this (step-by-step)
✅ 1. Verify the Agent record

Run:

SELECT * FROM agents WHERE name = 'your_agent_name';

Check these fields:

is_active
is_deleted
workspace_id
created_by
visibility
✅ 2. Compare with a working Agent

Find one that does show in UI:

SELECT * FROM agents WHERE id = 'working_agent_id';

👉 Diff the rows. You’ll likely spot missing flags.

✅ 3. Check required flags

Most systems require something like:

UPDATE agents
SET
is_active = true,
is_deleted = false,
visibility = 'public'
WHERE id = 'your_agent_id';
✅ 4. Ensure workspace/project binding

If your system is multi-tenant:

SELECT * FROM agents WHERE workspace_id IS NULL;

👉 If null → it won’t appear.

Fix:

UPDATE agents
SET workspace_id = 'your_workspace_id'
WHERE id = 'your_agent_id';
✅ 5. Trigger indexing / refresh

Depending on your stack:

Restart backend service
Clear cache (Redis)
Re-run ingestion pipeline
Rebuild embeddings (if required)
✅ 6. Check API response (critical)

Open DevTools → Network tab → look for:

GET /agents

Check if your agent appears in the response.

❌ Not in API → backend filtering issue
✅ In API but not UI → frontend bug