Explore the YugabyteDB YSQL API using sample datasets.
YugabyteDB and YugabyteDB client shell installations include sample datasets you can use to test out YugabyteDB. These are located in the
share directory of your installation. The datasets are also available in the sample directory of the YugabyteDB GitHub repository. The datasets are provided in the form of SQL script files. All of the datasets are PostgreSQL-compatible, and you can explore them using the ysqlsh shell to compare between PostgreSQL and the YugabyteDB YSQL API.
You can install and use the sample datasets using either a local installation of YugabyteDB, or by connecting to a cluster in YugabyteDB Managed (including your free cluster).
- Local install
- The ysqlsh shell is included with the YugabyteDB installation. For information on installing YugabyteDB, refer to Quick start.
- YugabyteDB Managed
- For information on connecting to your YugabyteDB Managed cluster using
ysqlshin cloud shell, refer to Connect using cloud shell.
- For information on connecting to your YugabyteDB Managed cluster using the
ysqlshclient installed on your computer, refer to Connect via client shells.
- The exercises can be run on free or standard clusters. To get started with YugabyteDB Managed, refer to Quick start.
Learn SQL and test your knowledge by creating the PostgreSQL Exercises database and trying out the available exercises.
Explore sample sports statistics for baseball, football, basketball, ice hockey, and soccer.