Quickstart

Get up and running with Sheeta DB in under 5 minutes. This guide walks you through connecting your first database, setting up tables with existing data, and generating insights.

Create a Local Database

When you open Sheeta DB, you must connect to a database to get started.

1. Download the sample dataset from this link.
2. Click Create Local DB to create and connect to a local database (powered by SQLite). This is the quickest way to work with a database project in Sheeta DB.

Import Data

Now let's import the sample data into your database.

1. Click Import Data and select purchases.csv.
2. Data import wizard will be shown. In this wizard, you can change table name, configure column names, types, primary keys, foreign keys, and other options. Data preview is shown in the second table below.
   For now, we use all default settings for simplicity. Click Import to proceed to data importing.
   
3. Once complete, the new purchases table appears in the database panel. Click on it to preview the data.

Explore Your Data

Let's find the oldest purchases for book products using the built-in sorting and filtering tools.

1. In the data preview for the purchases table, scroll to the purchase_date column.
2. Click the sort toggle once to sort by purchase_date in ascending order.
3. Scroll to the product_category column and click the filter icon.
4. Check Books to filter the results.

You now see a list of book product purchases sorted by oldest order date. No SQL required.

Generate Insights with AI

Let's use the AI assistant to analyze monthly sales trends for book products.

1. Collapse the left sidebar (or press Cmd+B) for more space, then open the agent panel by clicking the icon at the top right (or press Cmd+I).
2. The Sheeta Agent runs on top of a coding agent CLI. Install Claude Code or Codex (optional) on your device, then click Refresh.
   
3. Once a CLI is detected, the agent panel is ready for you to chat.
4. Send this message: What is the trend of monthly book product sales?
   The AI generates a query to analyze book sales trends and explains the result.
   
5. Click the query in the AI response, then click Run to see the full result.

Note: AI query limits depend on your account tier. To increase your limit, upgrade to Plus or Pro.

Visualize with a Dashboard

Now let's turn this result into a chart on a dashboard.

1. Send this message: Draw me a line chart in a new dashboard to show sales trends.
2. Click the dashboard link in the AI response to open it.
3. View the dashboard with the line chart showing monthly book product sales trends.