Support Postgres Protocol for broad BI Compatibility
in progress
Sahil Gupta
May be a bit of a stretch ask, but I'd love to see a MotherDuck-native feature akin to https://github.com/jwills/buenavista that allows BI tools to query against MotherDuck as if it were a Postgres server. This would be a pretty cool way to instantly support the majority of BI tools, imo!
N
Nicola Corda
If the postgress protocol is implemented fully, it allow out of the box connectivity with various BI tools (e.g. Looker) which already support Postgres.
When trying to connect Looker to postgres, for example we got this:
Java::OrgPostgresqlUtil::PSQLException: ERROR:
Catalog Error: Scalar Function with name
pg_backend_pid does not exist! Did you mean
"gen_random_uuid"? LINE 1: SELECT
pg_backend_pid() ^
Which imply that some relevant functions from postgres might need to be implemented
S
Sheila Sitaram
Nicola Corda: Hey Nicola! We recently updated the pg endpoint to support Looker - let us know if you have any questions
https://motherduck.com/docs/integrations/bi-tools/looker/
https://motherduck.com/docs/about-motherduck/release-notes/#may-22-2026
S
Sheila Sitaram
updated the status to
in progress
S
Sheila Sitaram
updated the status to
planned