Visper LogoVisper
Log inGet Started
← Back to learning center

Connecting to Your SQLite Database

Published: 8/18/2025

How to Connect Your SQLite Database in Visper

If you want to make your data in SQLite database instantly queryable and collaborate with your team using natural language (including but not limited to Text to SQL), connecting your SQLite database to Visper is the way to go. Once connected, you can chat with your data, run queries, and build live dashboards — all without writing SQL or code manually.

What is Visper?

Visper is a modern data platform that allows you to query your data and build beautiful dashboards through simple chat. This is more than just Text to SQL. Connect to your data sources, collaborate with your team in real-time, and let AI assist you in understanding your data.

Step 1: Create Your Database in Visper

  1. Go to the Datasource page and click the “Add Private Datasource” button.
  2. Select SQLite as your database type.
    • Give your database a descriptive name.
    • Upload your SQLite database file from your computer.
ImageImage

Step 2: Configure the Database Schema

  1. Visper will automatically analyze your database schema.
  2. You can enhance AI understanding by adding documents for tables and columns. This helps Visper provide more accurate answers tailored to your business context.
  3. By default, all tables are disallowed. Enable the tables you want users to access.
  4. Save the schema.
  5. Now, head to the Datasource page and start chatting with your data to query anything you need.
Image

Step 3: Handle Database Changes

Since SQLite is a local file-based database, updates require re-uploading the database file.

  1. If new data has been added, go to the database list page and click “Edit”.
  2. Re-upload the latest SQLite database file from your computer.
ImageImage

Step 3.1: Sync Database Schema

If your new database file has schema updates, follow these steps to sync:

  1. Click the Schema Link on the database list page and then click “Refresh”.
  2. Visper will analyze the updated schema and show a diff (added/removed tables/fields).
  3. You can:
    • Add documents to new tables/fields
    • Rename fields so previous documentation remains
  4. In most cases, no action is needed — just click “Save”.
ImageImage

Conclusion

Connecting your SQLite database to Visper makes data querying and dashboard building seamless. With automatic schema analysis, easy updates, and AI-assisted understanding, your team can collaborate faster and make smarter decisions.