# Built-in SQLite Demo Data

[dory-finn]

Built-in SQLite Demo Data

Background

New users currently need to create a connection and bring their own data before they can use Dory. This creates friction and delays the first meaningful experience.

Goal

Allow users to start using Dory immediately with no setup.

Open Dory → Run queries → Explore data

Proposal

1. Built-in Demo Database

• Include a prebuilt SQLite file (demo.sqlite)
• Available on first launch
• Loaded automatically if no existing data

2. Default Connection

Create a default connection:

• Name: Demo Database
• Type: SQLite
• Mark as demo

3. Demo Tables

Include simple but useful data:

logs

• id
• timestamp
• level
• service
• message
• duration_ms

orders

• order_id
• user_id
• amount
• status
• created_at

users

• id
• name
• country
• created_at

4. Data Volume

• logs: ~10k rows
• orders: ~1k rows
• users: ~100 rows

Expected Outcome

• Users can query immediately
• Users can try AI features without setup
• Better first-time experience