Archon Version

v0.1.0

Bug Severity

🟢 Low - Minor inconvenience

Bug Description

In the RESET_DB.sql script there is a missing line:

DROP POLICY IF EXISTS "Allow public read access to archon_page_metadata" ON archon_page_metadata;

After install, if you run this script and then tries to run the complete_setup.sql script it will fail due to this.

Steps to Reproduce

Install Archon, run the complete_setup.sql script, then the RESET-DB.sql, and then the complete_setup.sql, and it will fail due to this.

Expected Behavior

The complete_setup.sql should run without issues after running the RESET-DB.sql script.

Actual Behavior

The complete_setup.sql gives an error telling that the policy already exists.

Error Details (if any)

Affected Component

🔍 Knowledge Base / RAG

Browser & OS

PGAdmin4 on Windows 11 Pro

Additional Context

No response

Service Status (check all that are working)

• 🖥️ Frontend UI (http://localhost:3737)
• ⚙️ Main Server (http://localhost:8181)
• 🔗 MCP Service (localhost:8051)
• 🤖 Agents Service (http://localhost:8052)
• 💾 Supabase Database (connected)