Create Local PostgreSQL Databases using Supabase CLI

Create Local PostgreSQL Databases

Create Local PostgreSQL Databases using Supabase CLI


🌟 How to Spin up a PostgreSQL Development Server with Supabase CLI

There are several reasons you might want to create local PostgreSQL databases. You might be trying out Prisma (as suggested in this video). Alternatively you might need a local development database for an API you are building. Whatever your reason, you will see it can be pretty quick to create local PostgreSQL databases using Supabase CLI.

An alternative is Docker Compose, though you will see Supabase uses this method, behind the scenes, saving you having to create the docker-compose.yml file. Anyone let's crack on and see just how we can do the magic.

📹 Create Local PostgreSQL Databases: Video

Create Local PostgreSQL Databases using Supabase CLI

🖥 Code

Installing Docker

You need to have Docker and Docker Compose installed on your machine to run Supabase CLI.

# macOS
brew install docker
docker --version
docker-compose --version
Installing Docker

For Linux there are detailed instructions on the Docker site . You can see additional macOS installation instructions on the Docker site . There are also Windows Docker installation instructions there.

Installing Supabase CLI

One-off Supabase setup:

pnpm install-g supabase
Installing Supabase CLI

Spinning up a Local PostgreSQL Database

In your project folder, just run these two commands:

supabase init
supabase start
Spinning up a Local PostgreSQL Database

🗳️ Poll

Have you already tried Supabase?
Voting reveals latest results.

🙏🏽 Feedback

If you have found this video useful, see links below for further related content on this site. I do hope you learned one new thing from the video. Let me know if there are any ways I can improve on it. I hope you will use the code or starter in your own projects. Be sure to share your work on Twitter, giving me a mention so I can see what you did. Finally be sure to let me know ideas for other short videos you would like to see. Read on to find ways to get in touch, further below. If you have found this post useful, even though you can only afford even a tiny contribution, please consider supporting me through Buy me a Coffee.

Finally, feel free to share the post on your social media accounts for all your followers who will find it useful. As well as leaving a comment below, you can get in touch via @askRodney on Twitter and also askRodney on Telegram . Also, see further ways to get in touch with Rodney Lab. I post regularly on SvelteKit as well as Search Engine Optimisation among other topics. Also subscribe to the newsletter to keep up-to-date with our latest projects.