PostgreSQL

Integrating your PostgreSQL database with Hyper enhances your ability to perform complex queries and gain insights from your database. This guide will walk you through the steps to connect your PostgreSQL database to Hyper using the database connection information.

Prerequisites

• A running PostgreSQL database
• Access credentials (host, port, database name, username, and password)
• Network access from Hyper to your PostgreSQL database

Connecting PostgreSQL in the Hyper UI

Database Connection Information

1. Access Hyper UI: Log into the Hyper user interface.

2. Navigate to Data Sources: Go to the section where you can manage your data sources.

3. Add PostgreSQL: Select PostgreSQL from the list of data sources and initiate the connection process.

4. Provide Connection Details: Enter the required database connection information, including host, port, database name, username, and password.

5. Test Connection: Use the provided functionality to test if Hyper can successfully connect to your PostgreSQL database.

6. Save Configuration: Once the connection is successful, save the configuration.

Data Ingestion and Querying

With PostgreSQL connected, you can ingest and query data:

1. Schedule Data Sync: Configure synchronization settings to determine how often Hyper should pull data from PostgreSQL.

2. Data Mapping: Map your database tables and columns to the corresponding entities within Hyper.

3. Vectorize Data: Use Hyper's tools to vectorize your data, making it ready for RAG queries.

4. Initiate Data Sync: Start the data synchronization process to ingest data into Hyper.

5. Query Data: Execute RAG queries using Hyper's API to gain insights from your PostgreSQL data.

Access Control and Security

Ensure that access to the PostgreSQL data within Hyper is secure:

1. Role-Based Access Control: Define roles with specific permissions regarding the PostgreSQL data.

2. Authentication: Use Hyper's authentication system to manage which users or services can access or modify the data.

3. Secure Connection: Ensure that the connection to your PostgreSQL database is encrypted, using SSL if necessary.

4. Audit Logs: Keep audit logs of the data access and queries made through Hyper for security and compliance purposes.

Best Practices

• Regularly update your database credentials and rotate passwords.
• Limit access to the PostgreSQL database to only what is necessary for Hyper's operation.
• Monitor the performance impact on your PostgreSQL server due to data sync operations.

By following these steps, you can successfully integrate your PostgreSQL database with Hyper, leveraging its powerful querying capabilities for your data-driven applications.