Loading…
Chat with Amazon Redshift — Postgres-wire compatible, no SQL needed.
Amazon Redshift is AWS's petabyte-scale data warehouse, and it speaks the PostgreSQL wire protocol — which means iDBQuery's PostgreSQL connector works against it directly. Provide the cluster endpoint (often `<cluster-id>.<region>.redshift.amazonaws.com`), port 5439, database, user, and password. The AI introspects the schema (tables, columns, distribution keys, sort keys), then turns plain-English questions into safe Redshift SQL. Window functions, common-table expressions, JSON columns, and date/time math all work. Credentials are encrypted at rest. Read-only IAM credentials with `SELECT` on the relevant schemas are recommended.
Everything iDBQuery's Amazon Redshift connector supports out of the box.
In iDBQuery, choose PostgreSQL (Redshift uses the same protocol).
Host: `<cluster>.<account>.<region>.redshift.amazonaws.com`. Port: 5439.
Provide the database name and a read-only user with `SELECT` privileges.
If the cluster is in a VPC, allow our outbound IPs in your security group, or expose via a public endpoint.
iDBQuery introspects the schema in seconds. Ask your first question.
Free tier covers most teams. No credit card.
No credit card required · 1M tokens / month free