Sample Database
MindsDB provides a read-only PostgreSQL database pre-loaded with various datasets to help you test and explore the capabilities of Minds. These datasets are curated to cover a wide range of scenarios and use cases, allowing you to experiment with different data types and analysis techniques.
Our publicly accessible PostgreSQL database is designed for testing and playground purposes. By using these datasets, you can quickly get started with Minds, 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:
demo_config = DatabaseConfig(
description='House Sales Data',
type='postgres',
connection_args={
'user': 'demo_user',
'password': 'demo_password',
'host': 'samples.mindsdb.com',
'port': '5432',
'database': 'demo',
'schema': 'demo_data'
},
tables=['house_sales']
)
Below is the list of all avaiable datasets as tables.
Data Tables
- Name
fraud_detection- Description
This dataset 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.
- Name
customer_churn- Description
This dataset 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.
- Name
customer_support_chat- Description
This dataset contains data of chat with customer support, which can be used to train Large Language Models (LLMs) such as GPT, Llama2, and Falcon, both 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.
- Name
bank_customer_transactions- Description
This dataset 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.
- Name
telecom_customer_churn- Description
This dataset contains data on customer activities, preferences, and behaviors, which is useful for understanding customer engagement patterns, predicting churn, and analyzing customer feedback.
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.
- Name
house_sales- Description
This dataset contains data on houses sold throughout 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