Skip to main content

Databases

UIS provides multiple database options for different data models and use cases. PostgreSQL is the primary database used by other UIS services. The others are available for user workloads.

Services

ServiceTypeUsed by UISDeploy
PostgreSQLRelational (SQL)authentik, openwebui, litellm, unity-catalog, pgadmin./uis deploy postgresql
RedisIn-memory key-valueauthentik, redisinsight./uis deploy redis
MySQLRelational (SQL)./uis deploy mysql
MongoDBDocument (NoSQL)./uis deploy mongodb
QdrantVector search./uis deploy qdrant
ElasticsearchSearch & analytics./uis deploy elasticsearch

Quick Start

PostgreSQL and Redis are the most commonly needed databases:

./uis deploy postgresql
./uis deploy redis

Other databases are deployed on demand when specific applications need them.

PostgreSQL Extensions

UIS deploys the official Bitnami PostgreSQL image (PostgreSQL 18.3) which includes 8 pre-built extensions: pgvector (AI embeddings), PostGIS (geospatial), hstore, ltree, uuid-ossp, pg_trgm, btree_gin, and pgcrypto. See PostgreSQL details.