Hindsight: AI Long-Term Memory

Hindsight is a PostgreSQL-native long-term memory service for AI agents.

Pigsty v4.3 provides the app/hindsight configuration template (conf/app/hindsight.yml), using Pigsty-managed PostgreSQL by default instead of Hindsight’s built-in development database.

Quick Start

curl -fsSL https://repo.pigsty.io/get | bash; cd ~/pigsty
./bootstrap
./configure -c app/hindsight
vi pigsty.yml                 # edit domain, database password, and LLM settings
./deploy.yml
./docker.yml
./app.yml

Default access URLs:

• UI: http://hs.pigsty or http://<IP>:9999
• API: http://hs-api.pigsty or http://<IP>:8888

Key Settings

conf/app/hindsight.yml overrides /opt/hindsight/.env through apps.hindsight.conf. Key parameters:

• HINDSIGHT_API_PUBLISH_PORT: public API port, default 8888
• HINDSIGHT_UI_PUBLISH_PORT: public UI port, default 9999
• HINDSIGHT_DB_HOST / HINDSIGHT_DB_PORT / HINDSIGHT_DB_NAME / HINDSIGHT_DB_USER / HINDSIGHT_DB_PASSWORD
• HINDSIGHT_API_VECTOR_EXTENSION: default pgvector
• HINDSIGHT_API_TEXT_SEARCH_EXTENSION: default native
• HINDSIGHT_API_LLM_PROVIDER: default none

The default none LLM provider only ensures the service can start. Fact extraction, reflection, and consolidation require configuring Ollama or an OpenAI-compatible API.

Operations

cd /opt/hindsight
make up
make log
make info
make down
make pull

References

• Hindsight project: https://github.com/vectorize-io/hindsight
• Pigsty template: https://github.com/pgsty/pigsty/blob/main/conf/app/hindsight.yml