---
title: "Deploy Metabase Oracle"
description: "Dashboards and SQL questions on Oracle Database"
category: "Analytics"
url: https://railway.com/deploy/deploy-metabase-for-oracle-database
---

# Deploy Metabase Oracle

Dashboards and SQL questions on Oracle Database

**[Deploy Metabase Oracle on Railway](https://railway.com/template/deploy-metabase-for-oracle-database)**

Machine-readable deploy manifest (JSON, validated by TemplateCI): https://railway.com/deploy/deploy-metabase-for-oracle-database/manifest.json

- **Creator:** onepush
- **Category:** Analytics

## Template content

### Postgres https://devicons.railway.app/i/postgresql.svg

- **Image:** ghcr.io/railwayapp-templates/postgres-ssl:18

### metabase/metabase

- **Image:** metabase/metabase
- **Public domain:** Yes

## Documentation

# Deploy and Host self hosted Metabase Oracle (Open-Source BI for Oracle Database) on Railway

Metabase Oracle on Railway runs the Metabase app with a Postgres app database in one project, while Oracle stays outside as your data source.

## About Hosting Metabase Oracle open-source software on Railway (self hosted Metabase template)

Metabase queries Oracle live instead of copying your tables. Railway handles the containers, the Postgres volume, and HTTPS.

Oracle is not part of the template stack. Set MB_ENCRYPTION_SECRET_KEY early, before saving warehouse credentials, since the template leaves it unset.

## Why Deploy Metabase Oracle, the Oracle Analytics Cloud alternative on Railway (Railway Free Trial)

Oracle Analytics Cloud makes sense if you're already deep in Oracle licensing, but you trade away cost predictability and control. Metabase Cloud Starter runs $100/month for 5 users.

Railway is a singular platform to deploy your infrastructure stack. Railway will host your infrastructure so you don't have to deal with configuration, while allowing you to vertically and horizontally scale it.

By deploying Metabase Oracle on Railway, you are one step closer to supporting a complete full-stack application with minimal burden. Host your servers, databases, AI agents, and more on Railway.

### Railway vs Other Hosting Providers and VPS for Metabase Oracle self hosting

Metabase Oracle runs the same on any host, so the real choice is how much server work you want to own.

| Provider | What You Get with Railway | What You Get with the Other Provider |
| --- | --- | --- |
| DigitalOcean | Metabase and Postgres from a template, with a public HTTPS domain and no Droplet to patch. | Full Droplet control and predictable billing, but you handle the reverse proxy and TLS yourself. |
| AWS | Two linked services with Postgres wired in automatically and redeploys on git push. | Deep VPC and private networking for an Oracle host in your account, but IAM and security groups are on you. |
| Hetzner | A simple monthly bill for a small Metabase and Postgres stack with no server to patch. | Very low raw cost, but Docker, backups, and firewall rules are all manual. |

Pick Railway when you want Metabase Oracle running fast and your time spent on Oracle connections instead of server upkeep.

## Common Use Cases for hosted Metabase Oracle

- **Finance reporting off the ERP:** The general ledger lives in an Oracle instance finance guards closely. A read-only Oracle user scoped to the reporting schema keeps month-end dashboards refreshing without a ticket for every export.
- **Ops dashboards on a legacy schema:** An older app on Oracle 19c holds years of order and inventory data nobody wants to migrate. A few questions over selected views give floor managers a live view.
- **Ad hoc SQL for Oracle-fluent analysts:** Analysts who already write `TO_CHAR` and `CONNECT BY` can use the native SQL editor. Save good queries as questions so nobody rewrites them later.
- **Schema-limited access for contractors:** An outside firm gets a dedicated account that sees only one department's schemas. That is easier to audit than a shared login.
- **Cloud Oracle over mTLS:** Teams on Oracle Autonomous Database use the wallet-based keystore setup so Metabase connects over mutual TLS. Here the SSL settings are required, not optional.

## Dependencies for Metabase Oracle Docker hosted on Railway

The Railway template runs Metabase with a Postgres 18 app database for its own users, dashboards, and saved questions.

### Deployment Dependencies for Managed Metabase Oracle Service (BI for Oracle Database)

You need the metabase/metabase image (latest tag, port 3000), the Railway Postgres 18 service from ghcr.io/railwayapp-templates/postgres-ssl:18 with a volume, and a public domain for MB_SITE_URL.

### Implementation Details for Metabase Oracle (Using Metabase official docker image)

The official image does not bundle the Oracle driver, so download ojdbc8.jar from Oracle's JDBC downloads page, mount a plugins directory, and place it at /app/plugins/ojdbc8.jar before restarting.

## How does Metabase Oracle compare against other BI tools for Oracle Database platforms

Most teams pick a BI tool for Oracle based on who holds the license and who maintains the connection. Here is where each alternative wins.

### Metabase Oracle vs Oracle Analytics Cloud (Oracle Analytics Cloud Alternative)

- **Cost model:** Metabase Oracle OSS is free under AGPL, while Oracle Analytics Cloud is a paid managed service.
- **Operations:** You own the Metabase container, the JDBC driver, and the Postgres app database.
- **Where Oracle wins:** Tight integration with Oracle Cloud identity and enterprise support contracts.

### Metabase Oracle vs Tableau (Tableau Alternative)

- **Exploration:** Metabase Oracle's question builder lets analysts filter and group Oracle tables without writing SQL.
- **Visual depth:** Tableau has richer chart customization, so pixel-level dashboards still favor Tableau.
- **Licensing:** Tableau is per-seat commercial software, while Metabase Oracle OSS has no seat fees on your hosting.

### Metabase Oracle vs Power BI (Power BI Alternative)

- **Ecosystem fit:** Power BI is the natural pick if your organization lives in Microsoft 365 and Azure.
- **Self-hosting:** Metabase Oracle runs on Railway with no Windows or Azure requirement.
- **Where Power BI wins:** Deep DAX modeling and Microsoft-native sharing for large report estates.

### Metabase Oracle vs Apache Superset (Apache Superset Alternative)

- **Setup feel:** Metabase Oracle ships as a single container with a setup wizard, while Superset needs more pieces wired together first.
- **Flexibility:** Superset is stronger for highly configurable, code-heavy exploration across many engines.
- **Audience:** Metabase Oracle suits business users who want quick answers, and Superset suits engineers who want control.

## How to use Metabase Oracle (the OSS BI for Oracle Database)?

After the Railway deploy is green and the setup wizard is done, point Metabase at Oracle.

Fill in the **Display name**, the **Host** (an IP or domain name), and the **Port** (usually 1521). A pasted connection string pre-fills the rest.

Create a dedicated read-only account for Metabase rather than reusing an admin login. The docs don't give GRANT statements, so work out privileges with your DBA.

Use schema filters to limit what the sync scans. Scoping to the schemas your team queries keeps the first sync fast and the table picker usable.

## How to self host Metabase Oracle on other VPS Services (Metabase Oracle self hosting guide)

Railway's template gives you Metabase plus a Postgres app database, but Oracle is a separate system you connect to.

### Clone the Repository

Pull your stack definition onto the VPS so Metabase and Postgres settings stay versioned together.

```
git clone https://github.com/metabase/metabase.git
cd metabase
```

### Install Dependencies

Install Docker, then download `ojdbc8.jar` from Oracle's JDBC driver downloads page. Use a 19c or later database, since Oracle no longer supports pre-19 versions.

```
mkdir -p plugins
mv ~/Downloads/ojdbc8.jar plugins/
```

### Configure Environment Variables

Set the Metabase application database variables. Generate `MB_ENCRYPTION_SECRET_KEY` before saving any warehouse credentials, and never change it afterward.

```
MB_DB_TYPE=postgres
MB_DB_HOST=postgres
MB_DB_PORT=5432
MB_DB_USER=metabase
MB_DB_PASS=your-password
MB_DB_DBNAME=metabase
MB_SITE_URL=https://your-domain
MB_ENCRYPTION_SECRET_KEY=your-generated-key
```

### Start the Metabase Oracle Application

Run the stack with the plugins directory mounted, then go to Admin / Databases / Add a database and choose Oracle.

```
docker compose up -d
```

Railway handles the public HTTPS domain, the Postgres volume, and restarts for you, while on a VPS TLS, backups, and firewall rules stay on your plate.

## Official Pricing of Metabase Oracle (Metabase Oracle pricing)

Metabase Oracle is open source under the AGPL, so the software itself is free. You pay for infrastructure, and for a hosted plan if you want one.

Metabase Cloud pricing:

- **Cloud Starter:** $100/month, 5 users included, $6 per extra user.
- **Cloud Pro:** $575/month, 10 users included, $12 per extra user.
- **Enterprise:** starts at $20,000/year.

Self hosting on Railway means paying only for the Metabase container and its Postgres app database. Oracle licensing is separate, handled with Oracle.

## Metabase Oracle cloud vs self hosted comparison (Pricing, features, costs, and more)

Self hosting Metabase Oracle means you own uptime, upgrades, and the Oracle driver.

### Monthly cost of self hosting Metabase Oracle on Railway

The OSS build is free under AGPL, so your bill is infrastructure only. Oracle Database is billed separately.

### System Requirements for Hosting Metabase Oracle on a VPS

Budget enough memory for the Java runtime and the Postgres app database on the same box.

## Frequently Asked Questions (FAQs)

### Do I need a special driver for Metabase Oracle?

Yes. On Docker, mount that folder so the driver survives redeploys.

### What is the difference between SID and service name?

The SID (often ORCL or XE) names one database instance, while the service name is a TNS alias that can cover several. Fill in one or the other.

### Should I give Metabase a read-only Oracle account?

Yes. The Metabase docs leave the exact GRANT statements to you, so confirm them in Oracle's documentation.

### When should I turn on SSL for Oracle?

Turn it on when traffic crosses a network you don't fully control.

### Why did my Oracle credentials break after a redeploy?

Usually the encryption key changed or was never set.

### Is Metabase Oracle the same as Oracle Analytics Cloud?

No. Metabase is open-source and self-hosted, and it queries your Oracle data in place.


## Similar templates

- [Plausible WordPress](https://railway.com/deploy/deploy-plausible-for-wordpress-sites) — Cookie-free WordPress stats from your own Plausible
- [Typesense Multilingual](https://railway.com/deploy/deploy-typesense-multilingual-search) — Locale-aware multilingual search with Typesense
- [Formbricks](https://railway.com/deploy/formbricks-surveys) — Surveys, NPS and in-app feedback on your own Postgres, Hub and Cube

Open this page in a browser: https://railway.com/deploy/deploy-metabase-for-oracle-database