Why GameSchema?
Every tool your game data needs,
in one Unity plugin
From designing schemas visually to querying data with fully type-safe C# — GameSchema replaces a half-dozen ad-hoc solutions with a single, coherent workflow.
What's included
A breakdown of every major capability.
Visual Schema & Data Editor
Design your entire database without leaving Unity. Add tables, define columns with types and constraints, set foreign key relationships, and edit row data in a spreadsheet-style grid — all from a dedicated editor window. No SQL required.
C# Code Generation
Every table gets a generated data class and a static query class. Column references become typed C# fields. Rename a column in the editor, regenerate, and the compiler tells you everywhere that broke — instead of a runtime crash.
Type-Safe Query Builder
Queries are built from Column<T> references with operator overloads. Enemies.Level > 5 produces a Condition, not a string. Where(), OrderBy(), Limit(), and FetchAll() chain fluently with full IntelliSense support.
FK Navigation
Traverse foreign keys with .Follow() chains that resolve in a single SQL query, or use generated navigation properties for lazy-loading on a single row. Both approaches are type-safe — no string column names.
ERD Diagram
Open Window → GameSchema → ERD to see an auto-generated entity-relationship diagram of your entire schema. Tables, columns, types, and foreign key arrows — always up to date.
Schema Validation
The built-in validator catches common mistakes before they reach runtime: missing primary keys, duplicate column names, invalid identifiers, FK references to non-existent tables, and more.
VCS-Friendly Export
Export the database as one JSON file per table. Files are human-readable and diff cleanly in Git, Plastic SCM, or any other VCS. Enable auto-export in Settings to keep them in sync automatically.
Addressables Integration
Mark any TEXT column as an asset reference. The editor renders a drag-and-drop picker so designers reference assets by name. At runtime, AssetRef<T> provides async/await, callback, and coroutine loading helpers.
Multi-Platform
Ships with the open-source gilzoide/sqlite-net native plugin for Windows, macOS, Linux, and Android. iOS and WebGL use Unity's built-in SQLite — no extra binary needed. The same query code works everywhere.
How it compares
GameSchema vs other common approaches to game data in Unity.
| Feature | GameSchemaThis | Scriptable Objects | SQLite4Unity | sqlite-net (raw) | CSV / JSON files |
|---|---|---|---|---|---|
| Visual table & row editor | ✓ | ✓ | ✗ | ✗ | ✗ |
| Type-safe queries — no raw strings | ✓ | ✗ | ~ | ~ | ✗ |
| C# code generation | ✓ | ✗ | ✗ | ✗ | ✗ |
| FK / relational queries | ✓ | ✗ | ✓ | ✓ | ✗ |
| ERD diagram | ✓ | ✗ | ✗ | ✗ | ✗ |
| Schema validation | ✓ | ✗ | ✗ | ✗ | ✗ |
| VCS-diffable export | ✓ | ~ | ✗ | ✗ | ✓ |
| Addressables asset picker | ✓ | ✗ | ✗ | ✗ | ✗ |
| Multi-platform runtime | ✓ | ✓ | ✓ | ✓ | ✓ |
| No SQL knowledge required | ✓ | ✓ | ✗ | ✗ | ✓ |
| Active maintenance | ✓ | ✓ | ~ | ✓ | ✓ |
GameSchema
Purpose-built Unity SQLite toolchain with editor, code gen, and typed query API.
Scriptable Objects
Great for small, static datasets. No relational queries; large datasets become unwieldy.
SQLite4Unity
Popular Asset Store plugin. Raw connection API, no editor tooling or code generation.
sqlite-net (raw)
Solid C# ORM, but pure code — no Unity editor integration whatsoever.
CSV / JSON files
Simple to start with. No relations, no queries, no integrity constraints.
Dependencies
GameSchema is upfront about what it ships with and what's optional.
Open-source native SQLite3 plugin for Unity. Provides the sqlite3 binary for Windows, macOS, Linux, and Android. MIT licensed.
Unity SQLite (iOS & WebGL)
iOS, WebGL, tvOS, and visionOS ship SQLite as part of the OS / browser. No extra native lib is included or needed on those platforms.
Only required if you use AssetRef<T> loading helpers. Enable the GAMESCHEMA_ADDRESSABLES module from the Welcome window. Omit it entirely if you don't use Addressables.
Ready to build?
Free for personal and commercial use. Attribution required.