Learn SQL in your browser
A free SQL tutorial in short lessons on one shop database. Every example runs on real PostgreSQL in your browser, and the page checks your answers.
DbSchema Blog
Database design, migrations, SQL and everyday database work — explained with practical examples.
MySQL JDBC: com.mysql.cj.jdbc.Driver vs com.mysql.jdbc.Driver
Use com.mysql.cj.jdbc.Driver for MySQL Connector/J, fix the deprecation warning, and trace ClassNotFoundException and No suitable driver errors fast.
MySQL Connector/J: mysql-connector-j vs mysql-connector-java
mysql-connector-j vs mysql-connector-java: why the Maven coordinates changed in 8.0.31, which Connector/J version fits your MySQL server, and the dependency.
Fix 'Public Key Retrieval is not allowed' in MySQL JDBC
Fix MySQL JDBC 'Public Key Retrieval is not allowed': why caching_sha2_password causes it and when to use TLS, a pinned key or allowPublicKeyRetrieval.
MySQL JDBC URL and Connection String Parameters
The MySQL JDBC URL format, localhost and multi-host examples, and the connection properties worth setting: sslMode, connectionTimeZone and timeouts.
Text-to-SQL Tools and When to Trust Them
Text-to-SQL tools compared by what they see of your schema, BIRD and Spider 2.0 scores read 11 Oct 2026, and five checks before AI-written SQL runs.
SQL and Schema Tools for macOS: Choosing a SQL Client for Mac
Five SQL clients for Mac compared by engines, ER diagrams and Homebrew install, and how to install the free DbSchema Community Edition on macOS.
Data Modelling Tools for Databricks: What Reads Unity Catalog
Data modelling tools for Databricks compared: what Catalog Explorer draws free, and what DbSchema, erwin, ER/Studio, Hackolade and SqlDBM read.
Database Design Tools on Linux: Which Modellers Install Natively
Compare database design tools that run natively on Linux, see which modellers list only Windows and macOS, and open your own database in DbSchema Community
Data Modelling Tools for Snowflake: Five Tools Compared
Compare five data modelling tools for Snowflake on connection, reverse engineering, VARIANT support and model storage, with a fit guide per team.
Creating an ER Diagram From an Existing Database
Learn how to connect a tool to a live database, reverse-engineer a schema into an ER diagram, and uncover undeclared foreign keys with DbSchema.