Connecting to TablePlus

​

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: Create the Session Table

from agno.agent import Agent
from agno.db.postgres import PostgresDb
from agno.models.openai import OpenAIResponses

db = PostgresDb(db_url="postgresql+psycopg://ai:ai@localhost:5532/ai")

agent = Agent(
    model=OpenAIResponses(id="gpt-5.4-mini"),
    db=db,
)
agent.print_response("What is the capital of France?", session_id="tableplus-demo")

uv venv --python 3.12
source .venv/bin/activate

uv venv --python 3.12
.venv\Scripts\activate

uv pip install -U agno openai "psycopg[binary]" sqlalchemy

export OPENAI_API_KEY="your_openai_api_key_here"

$Env:OPENAI_API_KEY="your_openai_api_key_here"

python create_session.py

​

Step 3: Configure TablePlus

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

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