diff --git a/swh/storage/sql/logical_replication/replication_source.sql b/swh/storage/sql/logical_replication/replication_source.sql
new file mode 100644
index 00000000..a9cdadaf
--- /dev/null
+++ b/swh/storage/sql/logical_replication/replication_source.sql
@@ -0,0 +1,25 @@
+-- This file contains the instructions to create a replication source for
+-- PostgreSQL logical replication to another database.
+
+CREATE PUBLICATION softwareheritage;
+
+ALTER PUBLICATION softwareheritage ADD TABLE content;
+ALTER PUBLICATION softwareheritage ADD TABLE skipped_content;
+ALTER PUBLICATION softwareheritage ADD TABLE directory;
+ALTER PUBLICATION softwareheritage ADD TABLE directory_entry_file;
+ALTER PUBLICATION softwareheritage ADD TABLE directory_entry_dir;
+ALTER PUBLICATION softwareheritage ADD TABLE directory_entry_rev;
+ALTER PUBLICATION softwareheritage ADD TABLE person;
+ALTER PUBLICATION softwareheritage ADD TABLE revision;
+ALTER PUBLICATION softwareheritage ADD TABLE revision_history;
+ALTER PUBLICATION softwareheritage ADD TABLE release;
+ALTER PUBLICATION softwareheritage ADD TABLE snapshot;
+ALTER PUBLICATION softwareheritage ADD TABLE snapshot_branch;
+ALTER PUBLICATION softwareheritage ADD TABLE snapshot_branches;
+ALTER PUBLICATION softwareheritage ADD TABLE origin;
+ALTER PUBLICATION softwareheritage ADD TABLE origin_visit;
+ALTER PUBLICATION softwareheritage ADD TABLE origin_visit_status;
+ALTER PUBLICATION softwareheritage ADD TABLE metadata_fetcher;
+ALTER PUBLICATION softwareheritage ADD TABLE metadata_authority;
+ALTER PUBLICATION softwareheritage ADD TABLE raw_extrinsic_metadata;
+ALTER PUBLICATION softwareheritage ADD TABLE object_counts;