SQL Sample Files
SQL files contain Structured Query Language statements. They are used for database schema definitions, data imports, and as database dumps. Our sample SQL files use standard SQL syntax that works with MySQL, PostgreSQL, and SQLite.
Back to Example data files
Download SQL Sample Files
| File | File type | File size | Rows/Records | Mime type | Download example file |
|---|---|---|---|---|---|
| SQL Sample - CREATE TABLE Statements | SQL | 3 KB | N/A | application/sql | Download example file |
| SQL Sample - INSERT Data | SQL | 27 KB | ~120 rows | application/sql | Download example file |
| SQL Sample - Full Database Dump | SQL | 29 KB | ~120 rows | application/sql | Download example file |
| SQL Sample - Query Examples | SQL | 8 KB | 15+ queries | application/sql | Download example file |
About SQL files
SQL files are plain text files containing database commands. They typically include CREATE TABLE statements to define the schema, INSERT statements to populate data, and SELECT queries to retrieve data. Many database tools can execute SQL files directly.
Our sample SQL files cover common use cases: table creation with proper constraints and indexes, bulk data insertion, a full database dump, and a collection of query examples showing JOINs, aggregations, subqueries, and CTEs.
If you need an actual database file rather than SQL text, check our SQLite database sample. For flat data exports, our CSV files are a simpler option.