For the complete documentation index, see llms.txt. This page is also available as Markdown.

Amazon Redshift

Amazon Redshift with pREST β€” PostgreSQL-based warehouse connectivity with important dialect differences and a cautious support matrix.

Amazon Redshift is PostgreSQL-based but not full PostgreSQL. pREST can connect using the PostgreSQL driver path with vendor-required parameters. Label: Compatible with caveats.

Last updated: July 11, 2026 Β· Label: Compatible with caveats

Also see: Integrations β€” Amazon Redshift.


Supported features

Capability
Status

Connection

partial β€” requires Redshift-compatible URL options

Schema discovery

partial β€” validate against your cluster

CRUD

partial β€” prefer read-heavy / controlled writes; warehouse semantics differ

Filtering / ordering / pagination

partial β€” SQL differences vs PostgreSQL

Transactions

partial β€” Redshift transaction model differs

Scripts (/_QUERIES)

preferred path for Redshift-safe SQL

MCP (/_mcp)

partial β€” use read-only roles; verify tools against catalog

ACL / permissions

supported at pREST layer; also enforce IAM/DB grants


Connection

Use a PostgreSQL-style URL with Redshift’s OpenSourceSubProtocolOverride (see AWS docs on Redshift vs PostgreSQL):

export PREST_VERSION=2
export DATABASE_URL='postgresql://user:pass@redshift-endpoint:5439/dev?OpenSourceSubProtocolOverride=true'

Use PREST_PG_SSL_* for TLS. See Upgrading to v2 for SSL env naming.


Recommendations

  • Treat Redshift primarily as analytics / read access through pREST.

  • Prefer custom queries over assuming PostgreSQL CRUD parity.

  • For AI agents, use read-only credentials and MCP over HTTP.

  • Support labels and roadmap: Databases.

Also see the shorter integration note: Integrations β€” Amazon Redshift.


Known limitations

  • Important SQL and type differences vs PostgreSQL β€” read AWS: Redshift and PostgreSQL.

  • Not a substitute for a transactional OLTP PostgreSQL deployment.

  • Do not assume every pREST filter operator maps cleanly; test before production.


Last updated