Explore Schema and Table Data

Once you connect on the dashboard, everything you need to explore the database is a click away. Here is how to read the schema and look at rows.

Step 1: Connect first

1. Go to the Dashboard.
2. Pick your connection from the dropdown and click Connect.
3. If the page asks to install sqlite3 on the remote server, choose Attempt Install or install it manually, then try again.
4. When you see the blue “Connected to” badge, the tunnel is live.

Step 2: Read the schema panel

1. Scroll to the Schema card.
2. Type in the search box to filter tables by name.
3. Each table lists its columns and key constraints so you can understand the structure at a glance.

Step 3: View table data

1. In the Tables card, open the dropdown and select the table you want to inspect.
2. SQLitePilot loads a preview of the rows. A spinner appears while it fetches data.
3. Use the search box to quickly filter the visible rows by text.
4. If the table is empty, you will see a friendly notice so you know the request still worked.

Step 4: Download the file (optional)

1. Look at the connection badge at the top of the dashboard.
2. Click Download .db to grab the raw SQLite file.
3. On the free plan, downloads larger than 1 MB are blocked with a link to Upgrade.

Helpful reminders

• Use Disconnect when you are done to close the tunnel.
• Create different connections if you manage multiple .db files on the same server.
• Keep the browser tab open while data loads; refreshing clears the current preview.

With these controls you can review table designs and data without leaving SQLitePilot.