n8n AI & Database Management#

docker exec -it n8n_postgres16 psql -U n8n -d n8n

-- Count entries in knowledge base
SELECT COUNT(*) FROM n8n_knowledge_base;

-- Count entries in chat history
SELECT COUNT(*) FROM n8n_chat_histories;

-- View table structure
\d n8n_knowledge_base

-- Preview top 20 entries
SELECT * FROM n8n_knowledge_base LIMIT 20;

-- Clear all chat histories
DELETE FROM n8n_chat_histories;

-- Clear all knowledge base vectors
DELETE FROM n8n_knowledge_base;