AI Dashboard Builder

AI Configuration
Configure your Google Gemini AI API settings
Get your API key from Google AI Studio
DuckDB Connector Configuration
Configure the Postgres database connection details
Slug:
duckdb-sales-data
Secret Slug:
postgres-connection
Host:
205.178.182.205
Port:
5432
Database:
sales_demo
User:
sales_user
Password:
sales_password
Project Configuration
Set up your dashboard project details
MAPPIETABLETILETIMESERIES
Database Schema
Available tables and their column definitions

customers

Customer information and account details

customer_idINTEGER
Primary key for customer identification
customer_nameVARCHAR(255)
Full name of the customer or company
emailVARCHAR(255)
Customer email address
phoneVARCHAR(255)
Customer phone number
addressVARCHAR(255)
Customer street address
cityVARCHAR(255)
Customer city
countryVARCHAR(255)
Customer country
regionVARCHAR(255)
Geographic region (North America, Europe, etc.)
customer_segmentVARCHAR(255)
Customer segment (Individual, SMB, Enterprise)
registration_dateVARCHAR(255)
Date when customer registered
is_activeBOOLEAN
Whether the customer account is active

products

Product catalog with pricing and inventory information

product_idINTEGER
Primary key for product identification
product_nameVARCHAR(255)
Name of the product
categoryVARCHAR(255)
Product category
cost_priceINTEGER
Cost price of the product stored in cents
selling_priceINTEGER
Selling price of the product stored in cents
stock_quantityINTEGER
Available stock quantity
supplierVARCHAR(255)
Product supplier name
is_activeBOOLEAN
Whether the product is active in catalog

sales_representatives

Sales team member information and performance data

sales_rep_idINTEGER
Unique identifier for sales representative
rep_nameVARCHAR(255)
Full name of sales representative
emailVARCHAR(255)
Sales representative email address
phoneVARCHAR(255)
Sales representative phone number
regionVARCHAR(255)
Geographic region assigned to representative
hire_dateVARCHAR(255)
Date when representative was hired
is_activeBOOLEAN
Whether the representative is currently active
performance_multiplierDECIMAL(10,2)
Performance multiplier for commission calculation

sales_transactions

Sales transaction records with detailed financial information

transaction_idINTEGER
Unique transaction identifier
customer_idINTEGER
Foreign key to customers table
product_idINTEGER
Foreign key to products table
sales_rep_idINTEGER
Foreign key to sales_representatives table
transaction_dateVARCHAR(255)
Date of the transaction
quantityINTEGER
Quantity of products sold
unit_priceINTEGER
Price per unit stored in cents
discount_rateDECIMAL(10,2)
Discount rate applied
discounted_priceINTEGER
Price after discount stored in cents
total_amountINTEGER
Total transaction amount stored in cents
total_costINTEGER
Total cost of goods sold stored in cents
profitINTEGER
Profit from the transaction stored in cents
statusVARCHAR(255)
Transaction status
payment_methodVARCHAR(255)
Method of payment used
shipping_costINTEGER
Cost of shipping stored in cents