Connecting Postgres
PostGIS is a spatial database extension for PostgreSQL, enabling the storage, querying, and analysis of spatial data. Aino provides an easy way to connect, query, and visualize this spatial data.
How to Connect to PostgreSQL
In the left panel of the main screen, click Connected Databases.
Select New Postgres Connection.
Enter your connection details:
Source Name: A descriptive name for your data source in Aino. You’ll use this name when querying data through AI in your projects.
Host & Port: The host URL and port number of your PostgreSQL server.
Database: The name of your PostGIS-enabled database.
Username & Password: Your database credentials (note: these are not your Aino credentials).
Click Connect Database.
Reviewing the Connection and Data
Once the connection is created, please wait 2–3 minutes while Aino generates metadata. This metadata is essential for Aino’s AI to retrieve and analyze your PostGIS data effectively.
You can monitor the connection status on the Postgres card in the Connected Databases view.
By clicking on the Postgres card, you can:
Review connection details
Explore available tables and spatial data from your PostGIS database
Last updated