Repository files navigation

Access Prisma Studio securely through your web browser.

Share multiple database environments' access with colleagues. Deployed via Traefik for global access.

Size	Downloads	Discord

1. 🪨 Stable Debian-slim base image
2. 🔒 100%Docker Bench Security compliant
3. 👨‍💻 Open source for open audits
4. 📈 Regular updates
5. 0️ No extra dependencies

ARM64, ARMv7, x86, x64, PPC

A docker container with the latest LTS of NodeJS and the@prisma/cli module introspects your postgres database to auto-generate a prisma schema in the formschema.prisma.

Prisma Studio is then made available at the port specified to display your data source.

Setting up an on-premise HTTPS reverse proxy requires knowledge ofTraefik v2.This is a great starting point.

For help setting up an on-premise or cloud-agnostic HTTPS reverse proxy for Kubernetes,email me orcontact me on Discord

Make sure you securely generate new passwords for your postgres database for use with Prisma Studio.

1. Create a file named.env

2. Give.env the following contents:

PROJECT_NAME=demo-projectDOMAIN_NAME=domain.comPOSTGRES_DATABASE=developmentPOSTGRES_HOST=postgresPOSTGRES_PATH=/your/path/POSTGRES_USERNAME=postgresPOSTGRES_PASSWORD=postgresPOSTGRES_PORT=5432POSTGRES_DEFAULT_PORT=5432POSTGRES_IP_ADDRESS=192.168.254.20PRISMA_STUDIO_PORT=5555PRISMA_STUDIO_IP_ADDRESS=192.168.254.21NETWORK_NAME=traefik_proxy

You may have to change the port numbers forPostgres &Prisma Studio depending on the availability of your host machine.

For DevOps help setting up an on-premise or cloud-agnostic environment for software engineers,email me orcontact me on Discord

For example, before deploying this in a production environment, you will want to setup Traefik middleware for authentication to limit database access.

Create three.env configs

1. development
2. testing
3. production

Each config should have it's own database name (development, testing, and production), port number, plus unique passwords for each environment. Securely store the Postgres database credentials for safe-keeping.

This Template is licensed under the GNU General Public License, version 3 (GPLv3).

Timothy Miller

View my GitHub profile 💡

View my personal website 💻