​
[OPTIONAL] Install PostgreSQL locally

if needed, you can install PostgreSQL locally here

1

Installing on MacOS

To install on MacOS, you can use Brew

brew install postgresql@14
2

Start PostgreSQL

Then to start MySQL, use

brew services restart postgresql@14

NOTE: If you are connecting to a remote Postgres instance that is already running, you shouldn’t need to uninstall it locally. 

If you have installed locally using defaults, you will have Postgres running with these configuration properties:

	Host: localhost
	Port: 5432
	User: postgres
	Database: postgres
	Password:  <empty, no password>

​
Add A Connection To PostgreSQL

Tell Eve you want to connect to Postgres, and provide your host, port, user, and password

Copy the prompt below to follow along

Eve, add a connection to Postgres called “postgres_demo”, host: localhost, port: 5432, user: postgres, and the password is “” (no password needed), database: postgres and allow all bots to access it.

Eve adding a database connection to PostgreSQL

Clicking “Database Connections” in the Genesis GUI will show you that it has been added

Click Database Connections

postgres_demo and other databases connected appear here

​
[OPTIONAL] Create Sample Data

If you already have data in Postgres, you can proceed to the next section to harvest and analyze your data.  If your Postgres is empty, you can have Eve create some sample data for you

Copy the prompt below to follow along

Create in the postgres_demo database connection a new schema called GAMES, with tables VIDEO_GAMES and BOARD_GAMES. Add several (7 ish) columns to each database to track data about the respective types games. Then insert 5 sample rows in each table.

NOTE: It’s ok if Eve has to retry some steps or if she encounters issues, she should be able to resolve them on her own.

Once your data is created, you can ask Eve to show you some of it.

Copy the prompt below to follow along

Show me 3 rows from each of these tables

Eve showing the first 3 rows of the newly created synthetic dataset

NOTE: Your schema and data will vary based on what Eve decides to build for you.

​
AddingPostgreSQL To The Harvest

Tell Eve to add your PostgreSQL connection and the databases you want to use to the harvest.

Example: if you just created the databases above

Copy the prompt below to follow along

Add the postgres_demo database connection's postgres database to the harvest.

Eve adds the new database from the prompt above to the Harvester

After a few minutes, you should see the result on the Configuration / Harvest Summary screen

[IMAGE TO BE ADDED]

Harvester Status is where you can see all of the data sources being harvested

You can ask Eve questions about your data in PostgreSQL once the database connection appears on the Harvester Status page.

Copy the prompt below to follow along

Search for data on board games

Eve searches and finds data on board games

Once data has been found

Copy the prompt below to follow along

How many total games are in the data?

Eve queries the prompt above and shares her insights

​
Removing The Connection

 You also have the option to remove the connection.

NOTE: This will also remove related harvest information

Copy the prompt below to follow along

remove the connection to the postgres_demo database connection
Connecting To MySQLConnecting To SQLite