Connecting to TablePlus - Agno

Use TablePlus to inspect the tables Agno creates in your pgvector container: sessions, memories, and knowledge embeddings.

Step 1: Start Your `pgvector` Container

docker run -d \
  -e POSTGRES_DB=ai \
  -e POSTGRES_USER=ai \
  -e POSTGRES_PASSWORD=ai \
  -e PGDATA=/var/lib/postgresql \
  -v pgvolume:/var/lib/postgresql \
  -p 5532:5432 \
  --name pgvector \
  agnohq/pgvector:18

POSTGRES_DB=ai sets the default database name.
POSTGRES_USER=ai and POSTGRES_PASSWORD=ai define the database credentials.
The container exposes port 5432, mapped to 5532 on your local machine.

Step 2: Configure TablePlus

Launch TablePlus.
Click the + icon to add a new connection.
Choose PostgreSQL as the database type.

Fill in the connection details:

Host: localhost
Port: 5532
Database: ai
User: ai
Password: ai

Authorization Failed - JWT Verification Docker Connection Error

⌘I