Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How to Generate Realistic SQL Mock Data for Testing

Learn how to generate realistic synthetic SQL mock data and seed INSERT scripts for MySQL, PostgreSQL, SQLite, and SQL Server without exposing production PII.

MariaDB EXPLAIN FORMAT=JSON and ANALYZE FORMAT=JSON

Learn how MariaDB JSON plans show join order, access types, indexes, and row estimates, and how ANALYZE adds actual runtime statistics by executing the statement.

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.

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.