PostgreSQL Integration

You can connect Datograde to your PostgreSQL database to import and manage your data.

Setting up PostgreSQL Connection

Basic Configuration

1. Navigate to the Integrations page in your account settings
2. Click on PostgreSQL to open the configuration form
3. Fill in the following required connection details:
   • Host (e.g., localhost or your database URL)
   • Port (default is 5432)
   • Database name
   • Schema (defaults to "public")
   • Username
   • Password

Saving Your Configuration

1. Click the Save Configuration button
2. Datograde will test the connection and save your settings
3. Upon successful connection, you'll see a green checkmark with your database details

Managing Existing Configurations

Viewing Current Configuration

Once configured, you'll see your current PostgreSQL connection details:

• A green checkmark confirmation
• The connected database name
• The host address

Modifying Settings

1. Click the Edit Configuration button next to your existing configuration
2. Update any fields that need to be changed
3. Click Save Configuration to apply changes
4. Or click Cancel to keep existing settings

Troubleshooting

If you receive a "Failed to save configuration" alert:

• Verify all credentials are correct
• Ensure the database is accessible from your network
• Check that the specified user has proper access permissions
• Confirm the database port is open and accessible

Security Note

Your database credentials are encrypted and securely stored. We recommend:

• Using a dedicated read-only user for the connection
• Setting up appropriate database permissions
• Following your organization's security policies for database access