Schema Upload

Upload your database schema to LILA. LILA reads your table structures, column names, and relationships so it can translate natural language questions into accurate SQL queries. This page shows you how to upload or connect your schema.

Navigation: Dashboard → Projects → [Your Project] → Schema

Upload Methods

Provide your database structure to LILA in two ways.

Database Connection (Auto Mode)

Easiest method. Connect LILA directly to your database for automatic schema extraction.

  1. Click the database connection tab
  2. Enter your database credentials
  3. Click “Pull Schema” to retrieve structure automatically
  4. LILA analyzes tables, columns, and relationships

Security: LILA only reads your schema structure (table and column definitions). No actual data is accessed.

File Upload

Upload a SQL schema file exported from your database.

  1. Export your database schema to a .sql file
  2. Click the upload tab
  3. Select or drag your schema file
  4. Click “Generate Stats” to analyze the file
  5. LILA processes the SQL and extracts structure

Supported formats: PostgreSQL, MySQL, MariaDB, MSSQL, Oracle, SQLite

Schema Statistics

After uploading or connecting, you’ll see statistics about your schema:

  • Total tables detected
  • Table names and structures
  • Relationships between tables

Excluding Tables

Hide sensitive tables from the AI by excluding them from queries:

  1. Review the detected tables in Schema Stats section
  2. Select tables you want to exclude
  3. Click “Update Schema” to save your selections

Example use case: Exclude internal tables like migrations, sessions, or logs that users shouldn’t query.

When to Update

Re-upload your schema whenever you:

  • Add new tables to your database
  • Change column names or types
  • Add or remove relationships
  • Need to update excluded tables list

The “Update Schema” button saves your table exclusion preferences without re-uploading.