Mysql fdw
lastmod 2026-11-10created 2026-02-272 edits
mysql_fdw is a foreign data wrapper (FDW) extension that connects MySQL and MariaDB tables to PostgreSQL as foreign tables. After registering a foreign server and a user mapping and defining foreign tables, they can be queried and joined inside PostgreSQL like ordinary tables, and conditions are pushed down to the MySQL side to reduce the amount of data transferred. It works the same way as postgres_fdw, which connects other PostgreSQL servers, and is used for data migration or unified queries across heterogeneous databases.