2026-09-286 min#postgres#database
Database Schema Diagram Tool: 5 Ways to Visualize PostgreSQL
Compare 5 database schema diagram tools for PostgreSQL: from psql to live connection string. Find the one that fits your workflow.
Blog
PostgreSQL schema guides
Practical guides on ER diagrams, connection strings, and the real schemas behind Supabase, Stripe, and modern e-commerce, all grounded in live PostgreSQL introspection.
2026-09-287 min#django#database
Django Auth Tables and Permissions Explained
Every table Django creates for authentication: auth_user, auth_group, auth_permission, what each one does and how the permission system works.
2026-09-285 min#database#tutorial
What Is an ER Diagram and How to Read One
What an ER diagram actually shows: entities, attributes, relationships, and cardinality, and how to read one in under 5 minutes.
2026-09-254 min#postgres#database
How to Format SQL in PostgreSQL: Styles, Tools, and Team Standards
Messy single-line SQL slows everyone down. How to format PostgreSQL properly, which style to pick, and a free formatter that runs in your browser.
2026-09-255 min#postgres#database
Database Schema Health Check: 7 Things to Audit Before You Ship
Run a 60-second health check on your PostgreSQL schema: missing primary keys, unindexed foreign keys, naming drift, and the fixes for each.
2026-09-154 min#postgres#database
SQL to Schema Diagram Online: Convert SQL to ERD in Seconds
Convert SQL to a schema diagram online. Paste your CREATE TABLE statements and get an interactive ER diagram instantly. No signup required.
2026-09-155 min#postgres#database
Free Online Database Diagram Tool: Visualize Your Schema in Seconds
Need a free database diagram tool? Paste SQL or connect to PostgreSQL to generate ER diagrams instantly. No signup, no limits, no catch.
2026-09-085 min#database#tutorial
dbdiagram.io vs dbdiagramr vs DrawSQL: Honest Comparison
The real differences between dbdiagram.io, dbdiagramr, and DrawSQL: pricing, features, Supabase integration, and which one fits your workflow.
2026-09-085 min#supabase#postgres
Supabase Connection String: IPv6, ENOTFOUND, and the Transaction Pooler Fix
Why Supabase throws ENOTFOUND and ETIMEDOUT errors, the IPv6 vs IPv4 problem, and how the transaction pooler port (6543) fixes most connection issues.
2026-09-084 min#database#documentation
Why Schema Diagrams Go Stale (and the Fix)
Schema diagrams drift out of sync within weeks. Here's why it happens, the three fixes that actually work, and how to make your diagram self-healing.
2026-09-086 min#postgres#database
information_schema vs pg_catalog: Which Should You Query?
The difference between information_schema and pg_catalog in PostgreSQL: which one to use for what, performance gotchas, and common queries.
2026-09-085 min#database#documentation
How to Document Your Database Schema for a Team
A practical guide to documenting your database schema so your team actually reads it: naming conventions, inline comments, and the one-page cheat sheet.
2026-09-086 min#laravel#database
Laravel Default Database Tables Explained
Every table Laravel creates by default: users, password_resets, failed_jobs, personal_access_tokens, what each one does and what to change.
2026-09-085 min#nextjs#auth
NextAuth / Auth.js Database Schema Explained
Every table NextAuth (Auth.js) creates in your database: users, accounts, sessions, verification_tokens, and how they connect.
2026-09-087 min#postgres#database
E-commerce Database Schema for PostgreSQL: The 11 Tables Every Store Needs
The 11-table PostgreSQL schema that powers Shopify and WooCommerce: customers, products, carts, orders, payments, and reviews with relationships.
2026-09-086 min#postgres#database
Stripe Billing Schema for PostgreSQL: Customers to Payment Intents
Model Stripe's billing objects as PostgreSQL tables: customers, products, prices, subscriptions, invoices, and payment intents with foreign keys.
2026-08-255 min#supabase#postgres
Supabase Auth Schema Explained: Users, Identities, Sessions
What lives in Supabase's auth schema: users, identities, sessions, refresh_tokens, and how they relate when you introspect a live database.
2026-08-205 min#postgres#supabase
PostgreSQL Connection String: Supabase, Neon, Railway
Every piece of a PostgreSQL connection string, broken down, plus why Supabase's transaction pooler (port 6543) is the gotcha most tutorials skip.
2026-08-186 min#postgres#database
How to Visualize a PostgreSQL Schema: 5 Ways Compared
Compare five practical ways to turn a Postgres database into a readable schema diagram: from psql to a live connection string, and pick the one that fits.
Want to see your own schema?
Paste a PostgreSQL connection string and get an interactive ER diagram in under 10 seconds. No signup required.