.png)
12 hours ago
1
API-powered migration from Metabase to local Postgres
demo.mp4MetaExodus is a simple tool that copies your entire database from Metabase to your local PostgreSQL. It connects to Metabase via API, grabs all your tables and data, then recreates everything locally. Perfect for developers who need a local copy of production data for testing and development.
- Connects to your Metabase instance
- Downloads all table structures and data
- Creates identical tables in your local PostgreSQL
- Shows progress with nice terminal output
- Handles errors gracefully with retries
- Node.js 16+
- PostgreSQL running locally (with the same schema)
- Access to a Metabase instance
git clone <this-repo>
cd metaexodus
yarn install
Copy the template and fill in your details:
Edit .env with your information:
# Your local PostgreSQL database
DB_LOCAL_HOST=localhost
DB_LOCAL_PORT=5432
DB_LOCAL_NAME=my_local_db
DB_LOCAL_USERNAME=postgres
DB_LOCAL_PASSWORD=your_password
# Your Metabase instance
METABASE_BASE_URL=https://your-metabase.com
METABASE_DATABASE_ID=1
DB_REMOTE_USERNAME=your_metabase_email
DB_REMOTE_PASSWORD=your_metabase_password
# Optional settings
DB_LOCAL_SSL=false
DB_BATCH_SIZE=1000
That's it! Watch as it copies everything over.
- Go to your Metabase admin panel
- Click on "Databases"
- Find your database in the list
- The ID is in the URL when you click on it: /admin/databases/4 means ID is 4
Want to contribute or modify the code?
# Run tests
yarn test
# Check code style
yarn lint
# Fix code style issues
yarn lint:fix
- Incremental sync: Only copy new/changed data instead of everything
- Schema-only mode: Just copy table structures without data
- Selective table sync: Choose which tables to copy
- Resume interrupted syncs: Continue where you left off if something fails
- Multiple database support: MySQL, SQLite, etc.
- Requires existing database schema (can't create the database for you)
- Only works with PostgreSQL locally
- No way to exclude sensitive tables or columns
