Sample Database
MindsDB provides a read-only PostgreSQL database pre-loaded with various datasets. These datasets are curated to cover a wide range of scenarios and use cases, allowing you to experiment with different features of MindsDB.
Our publicly accessible PostgreSQL database is designed for testing and playground purposes. By using these datasets, you can quickly get started with MindsDB, understand how it works, and see how it can be applied to real-world problems.
Connection
To connect to our read-only PostgreSQL database and access the example datasets, use the following connection parameters:
Below is the list of all avaiable datasets as tables.
Data Tables
Here are the tables converted into Markdown format:
Fraud Detection Dataset
This fraud_detection table contains data on mobile money transactions where each step represents an hour of simulation.
| step | type | amount | nameOrig | oldbalanceOrg | newbalanceOrig | nameDest | oldbalanceDest | newbalanceDest | isFraud | isFlaggedFraud |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PAYMENT | 9839.64 | C1231006815 | 170136.0 | 160296.36 | M1979787155 | 0.0 | 0.0 | 0 | 0 |
| 1 | PAYMENT | 1864.28 | C1666544295 | 21249.0 | 19384.72 | M2044282225 | 0.0 | 0.0 | 0 | 0 |
| 1 | TRANSFER | 181.0 | C1305486145 | 181.0 | 0.0 | C553264065 | 0.0 | 0.0 | 1 | 0 |
To learn more about this dataset, please visit this link.
Customer Churn Dataset
This customer_churn table contains data of a U.S. bank customer churn.
| RowNumber | CustomerId | Surname | CreditScore | Geography | Gender | Age | Tenure | Balance | NumOfProducts | HasCrCard | IsActiveMember | EstimatedSalary | Exited |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 15634602 | Hargrave | 619 | France | Female | 42 | 2 | 0 | 1 | 1 | 1 | 101348.88 | 1 |
| 2 | 15647311 | Hill | 608 | Spain | Female | 41 | 1 | 83807.86 | 1 | 0 | 1 | 112542.58 | 0 |
| 3 | 15619304 | Onio | 502 | France | Female | 42 | 8 | 159660.8 | 3 | 1 | 0 | 113931.57 | 1 |
To learn more about this dataset, please visit this link.
Customer Support Chat Dataset
This customer_support_chat table contains data of chat with customer support, which can be used to train Large Language Models (LLMs) for Fine Tuning and Domain Adaptation.
| flags | instruction | category | intent | response |
|---|---|---|---|---|
| B | question about cancelling order Order Number | ORDER | cancel_order | I’ve understood you have a question regarding canceling order Order Number, and I’m here to provide you with the information you need. Please go ahead and ask your question, and I’ll do my best to assist you. |
| BQZ | i have a question about cancelling order Order Number | ORDER | cancel_order | I’ve been informed that you have a question about canceling order Order Number. I’m here to assist you! Please go ahead and let me know what specific question you have, and I’ll provide you with all the information and guidance you need. Your satisfaction is my top priority. |
To learn more about this dataset, please visit this link.
Bank Customer Transactions Dataset
This bank_customer_transactions table contains data of customer transactions with demographic and shopping behavior information.
| Customer ID | Name | Surname | Gender | Birthdate | Transaction Amount | Date | Merchant Name | Category |
|---|---|---|---|---|---|---|---|---|
| 752858 | Sean | Rodriguez | F | 2002-10-20 | 35.47 | 2023-04-03 | Smith-Russell | Cosmetic |
| 26381 | Michelle | Phelps | 1985-10-24 | 2552.72 | 2023-07-17 | Peck, Spence and Young | Travel | |
| 305449 | Jacob | Williams | M | 1981-10-25 | 115.97 | 2023-09-20 | Steele Inc | Clothing |
To learn more about this dataset, please visit this link.
Telecom Customer Churn Dataset
This telecom_customer_churn table contains data on customer activities, preferences, and behaviors.
| age | gender | security_no | region_category | membership_category | joining_date | joined_through_referral | referral_id | preferred_offer_types | medium_of_operation | internet_option | last_visit_time | days_since_last_login | avg_time_spent | avg_transaction_value | avg_frequency_login_days | points_in_wallet | used_special_discount | offer_application_preference | past_complaint | complaint_status | feedback | churn_risk_score |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18 | F | XW0DQ7H | Village | Platinum Membership | 17-08-2017 | No | xxxxxxxx | Gift Vouchers/Coupons | ? | Wi-Fi | 16:08:02 | 17 | 300.63 | 53005.25 | 17 | 781.75 | Yes | Yes | No | Not Applicable | Products always in Stock | 0 |
| 32 | F | 5K0N3X1 | City | Premium Membership | 28-08-2017 | ? | CID21329 | Gift Vouchers/Coupons | Desktop | Mobile_Data | 12:38:13 | 16 | 306.34 | 12838.38 | 10 | Yes | No | Yes | Solved | Quality Customer Care | 0 | |
| 44 | F | 1F2TCL3 | Town | No Membership | 11-11-2016 | Yes | CID12313 | Gift Vouchers/Coupons | Desktop | Wi-Fi | 22:53:21 | 14 | 516.16 | 21027 | 22 | 500.69 | No | Yes | Yes | Solved in Follow-up | Poor Website | 1 |
To learn more about this dataset, please visit this link.
House Sales Dataset
This house_sales table contains data on houses sold throughout the years.
| saledate | ma | type | bedrooms | created_at |
|---|---|---|---|---|
| 2007-09-30 | 441854 | house | 2 | 2007-02-02 15:41:51.922127 |
| 2007-12-31 | 441854 | house | 2 | 2007-02-23 22:36:08.540248 |
| 2008-03-31 | 441854 | house | 2 | 2007-02-25 19:23:52.585358 |
To learn more about this dataset, please visit this link.