SQLiz

Learn SQL and Databases with Practical Examples

SQLiz is a practical learning library for SQL and databases. Browse query examples for MySQL, PostgreSQL, SQLite, MariaDB, and SQL Server, alongside references and setup guides for Oracle, MongoDB, Redis, and more. Format SQL for six database dialects, explore the SQL and database tools, or run SQLite queries in a temporary browser database. You can also compare SQL patterns across databases, search for a function or diagnose a common MySQL or PostgreSQL error, choose a database tutorial below, or browse all articles for installation and programming guides.

MySQL Tutorial PostgreSQL Tutorial MariaDB Tutorial MySQL Reference PostgreSQL Reference SQLite Function Reference MariaDB Reference MongoDB Reference Oracle Reference SQL Server Reference Sakila Tutorial Developer Tools 6 Apps

How to Convert CSV to MySQL INSERT Statements

Convert CSV or spreadsheet data into MySQL CREATE TABLE and batched INSERT statements with type inference, NULL handling, escaping, and browser-local processing.

How to Convert CSV to PostgreSQL INSERT Statements

Convert CSV data into PostgreSQL CREATE TABLE and batched INSERT statements with PostgreSQL types, NULL handling, escaping, and browser-local processing.

How to Convert Excel Data to SQL INSERT Statements

Convert Excel or Google Sheets data into SQL CREATE TABLE and INSERT statements for MySQL, PostgreSQL, SQLite, SQL Server, and Oracle.

How to Open a SQLite .db File Online

Open a SQLite .db, .sqlite, or .sqlite3 file online in your browser, run SQL queries, inspect tables, and download changes without uploading the database.

How to Test SQLite Queries Online

Test SQLite queries online with a real browser-based SQLite database. Run SELECTs, joins, CTEs, JSON functions, window functions, and schema changes without installing SQLite.

SQLite Online Editor Without Installation

Use SQLite without installing software. Create tables, insert rows, run queries, test SQLite syntax, and export a database directly from your browser.

SQL to TypeScript & Types Converter Online (Pydantic, Go, Rust, JSON Schema)

Convert SQL CREATE TABLE statements to TypeScript interfaces, Python Pydantic models, Go structs, Rust structs, and JSON Schema online for PostgreSQL, MySQL, SQLite, and SQL Server.

SQLite Playground Online – Run SQL in Your Browser

Run SQLite online in a browser-based SQL playground and editor. Execute queries, open local .db files, use sample data, and export your database without uploading it.

How to Convert SQL CREATE TABLE to TypeScript, Pydantic, and Go Types

Convert database CREATE TABLE DDL statements into TypeScript interfaces, Python Pydantic models, and Go structs with type mappings, nullability rules, and in-browser conversion.

How to Format SQL for MySQL, PostgreSQL, SQLite, Oracle, and SQL Server

Learn how SQL formatting differs across MySQL, PostgreSQL, SQLite, Oracle PL/SQL, SQL Server T-SQL, and MariaDB, and format each dialect safely in your browser.

How to Convert an Excel Column to a SQL IN Clause

Convert an Excel or Google Sheets column into a SQL IN (…) list. Handle quotes, duplicates, numeric IDs, text values, Oracle 1000-item limits, and PostgreSQL arrays.

How to Convert CSV to SQL INSERT Statements

Convert CSV or Excel-exported data into SQL CREATE TABLE and INSERT statements for MySQL, PostgreSQL, SQLite, SQL Server, or Oracle, with type inference and safe batching.

How to Run SQLite Online in Your Browser (No Installation)

Run SQLite online without installing a database server. Use a browser-based SQLite playground to execute SQL, open local .db files, test queries, and export changes privately.

SQL Formatter Online for MySQL, PostgreSQL, SQLite, and More

Free online SQL formatter and beautifier for MySQL, MariaDB, PostgreSQL, SQLite, Oracle, and SQL Server. Format queries locally in your browser.

JSON to SQL Converter Online (CREATE TABLE & INSERT Statements)

Convert JSON arrays, objects, or NDJSON to SQL CREATE TABLE and batch INSERT statements online for SQLite, MySQL, PostgreSQL, SQL Server, and Oracle.

SQL IN Clause Generator Online (List to SQL IN)

Convert lists from Excel, CSV, or logs into clean SQL IN clauses online. Supports automatic deduplication, quote escaping, and database limit chunking.

SQL Bulk and Batch Insert by Database: Syntax, Limits & Performance

Compare multi-row batch insert syntax, row constructor limits, and bulk loading methods across MySQL, MariaDB, PostgreSQL, SQLite, SQL Server, and Oracle.

SQL JSON Aggregation by Database: Arrays and Objects

Compare JSON array and object aggregation in MySQL, MariaDB, PostgreSQL, SQLite, SQL Server, and Oracle, including ordering, NULL, and version differences.

List Views in SQL: MySQL, MariaDB, PostgreSQL & More

Compare how to list views in MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and Oracle, including schemas, system views, and permissions.

JSON Schema Validation in MySQL and MariaDB

Compare MySQL and MariaDB JSON_SCHEMA_VALID(): minimum versions, Draft 4 versus Draft 2020, reference limits, and MySQL validation reports.

List Databases in SQL: MySQL, MariaDB, PostgreSQL & More

Compare how MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and Oracle list databases, schemas, or attached files, including visibility limits.

SQL Server JSON Path Expressions

Learn SQL Server JSON path syntax for keys, array indexes, lax and strict modes, and SQL Server 2025 array wildcards.

How to Size a MySQL Connection Pool

Calculate a safe MySQL pool ceiling across app replicas, then tune it with database and application metrics instead of guessing.

MySQL Error 2015: Named Pipe Connection on Windows

Troubleshoot MySQL Error 2015 on Windows by checking named-pipe support, the pipe name, and client access permissions.

How to Upgrade PostgreSQL 14 to PostgreSQL 18

PostgreSQL 14 support ends Nov 12, 2026. Plan an upgrade to 18 with pg_upgrade checks, checksum compatibility, a tested backup, and application validation.

How to Upgrade PostgreSQL 17 to PostgreSQL 18

Plan a PostgreSQL 17 to 18 major-version upgrade with pg_upgrade: check extensions and checksums, test backups, use check mode, and verify the new cluster.

MySQL Error 1114: The Table Is Full

Diagnose MySQL Error 1114 by checking disk space, the affected storage engine, InnoDB tablespaces, MEMORY limits, and query temporary tables.

PostgreSQL Error 22007: Invalid Datetime Format

Fix PostgreSQL SQLSTATE 22007 by checking DateStyle, using ISO date values, and parsing fixed input formats explicitly.

MySQL Error 1040: Too Many Connections

Recover from MySQL Error 1040 with an administrator connection, inspect sessions, and size application pools against max_connections.

MySQL Error 1206: Lock Table Full

Fix MySQL Error 1206 by shrinking oversized transactions, batching row changes, checking query indexes, and sizing the InnoDB buffer pool.