Learn Docker With My Newest Course

Dive into Docker takes you from "What is Docker?" to confidently applying Docker to your own projects. It's packed with best practices and examples. Start Learning Docker →

Manage and Create Diagrams of Your SQL Database for Free with DBeaver

blog/cards/manage-and-create-diagrams-of-your-sql-database-for-free-with-dbeaver.jpg

In this 5 minute video, we'll go over how to view entity relationship diagrams and modify your data with an open source database tool.

Quick Jump: Exploring Your Database with DBeaver

I’m all for using the command line and use the psql tool quite frequently for interacting with PostgreSQL databases but sometimes you just want a graphical tool to visualize things or help make quick edits.

That’s where DBeaver comes into play. It’s a free / open source cross platform database exploration tool that works with PostgreSQL, MySQL, MariaDB and other SQL databases.

This video looks at how to generate fancy diagrams of your database relationships in 1 mouse click and also how to quickly edit values in any table. It’s great for development.

Exploring Your Database with DBeaver

Timestamped Table of Contents

  • 0:13 - Using DBeaver to create an ERD for a few related tables
  • 1:08 - Looking at a complete ERD from my upcoming course hosting platform
  • 2:23 - Listing every index in your database
  • 2:52 - Looking at columns, indexes, foreign keys and constraints for a table
  • 3:09 - Browsing and editing data in a specific table
  • 3:59 - Why not use pgAdmin if you’re using PostgreSQL?
  • 4:18 - Great for developers who work with multiple databases on a regular basis
  • 4:37 - Downloading DBeaver from GitHub or their official website

What database tools do you use in development? Let me know below.

Never Miss a Tip, Trick or Tutorial

Like you, I'm super protective of my inbox, so don't worry about getting spammed. You can expect a few emails per month (at most), and you can 1-click unsubscribe at any time. See what else you'll get too.


Comments