AI Integration for Self-Hosted

To use AI-powered Chat on your self-hosted installation, follow these steps:

• Ensure you have pgDash version 3.5.27 or above installed. If you need to upgrade, follow the instructions in the Self-hosted page.

• Currently, OpenAI and Google Gemini are supported as AI providers. Obtain an API key from either of these providers. pgDash uses the chat completion / text generation APIs fot the AI-powered Chat feature.

• Edit /etc/pgdash/pgdash.cfg and locate the [ai] section. Set the keys appropriately:

  • provider to either openai or gemini

  • apikey to the API key from OpenAI or Gemini

  • model to any model from the provider that supports chat completion / text generation.

pgDash benefits a lot from larger context windows. As of now, we recommend using Google Gemini with gemini-2.5-pro model.

All responses of AI must be verified before use.

Finally, note that OpenAI or Google Gemini will charge you for the API calls made to enable the AI responses.