diff --git a/sql/upgrades/029.sql b/sql/upgrades/029.sql
new file mode 100644
index 00000000..3320777c
--- /dev/null
+++ b/sql/upgrades/029.sql
@@ -0,0 +1,75 @@
+-- SWH DB schema upgrade
+-- from_version: 28
+-- to_version: 29
+-- description: add metadata column to revision table
+
+insert into dbversion(version, release, description)
+      values(29, now(), 'Work In Progress');
+
+ALTER TABLE revision
+	ADD COLUMN metadata jsonb;
+
+CREATE OR REPLACE FUNCTION swh_revision_add() RETURNS void
+    LANGUAGE plpgsql
+    AS $$
+begin
+    perform swh_person_add_from_revision();
+
+    insert into revision (id, date, date_offset, committer_date, committer_date_offset, type, directory, message, author, committer, metadata, synthetic)
+    select t.id, t.date, t.date_offset, t.committer_date, t.committer_date_offset, t.type, t.directory, t.message, a.id, c.id, t.metadata, t.synthetic
+    from tmp_revision t
+    left join person a on a.name = t.author_name and a.email = t.author_email
+    left join person c on c.name = t.committer_name and c.email = t.committer_email;
+    return;
+end
+$$;
+
+alter type revision_entry
+    drop attribute parents,
+    drop attribute synthetic,
+    add attribute metadata jsonb,
+    add attribute synthetic boolean,
+    add attribute parents bytea[];
+
+alter type revision_log_entry
+    drop attribute synthetic,
+    add attribute metadata jsonb,
+    add attribute synthetic boolean;
+
+CREATE OR REPLACE FUNCTION swh_revision_get() RETURNS SETOF revision_entry
+    LANGUAGE plpgsql
+    AS $$
+begin
+    return query
+        select t.id, r.date, r.date_offset,
+               r.committer_date, r.committer_date_offset,
+               r.type, r.directory, r.message,
+               a.name, a.email, c.name, c.email, r.metadata, r.synthetic,
+	       array_agg(rh.parent_id::bytea order by rh.parent_rank)
+                   as parents
+        from tmp_revision t
+        left join revision r on t.id = r.id
+        left join person a on a.id = r.author
+        left join person c on c.id = r.committer
+        left join revision_history rh on rh.id = r.id
+        group by t.id, a.name, a.email, r.date, r.date_offset,
+               c.name, c.email, r.committer_date, r.committer_date_offset,
+               r.type, r.directory, r.message, r.metadata, r.synthetic;
+    return;
+end
+$$;
+
+CREATE OR REPLACE FUNCTION swh_revision_log(root_revision sha1_git) RETURNS SETOF revision_log_entry
+    LANGUAGE sql STABLE
+    AS $$
+    select revision.id, date, date_offset,
+	committer_date, committer_date_offset,
+	type, directory, message,
+	author.name as author_name, author.email as author_email,
+	committer.name as committer_name, committer.email as committer_email,
+        revision.metadata, revision.synthetic
+    from swh_revision_list(root_revision) as rev_list
+    join revision on revision.id = rev_list
+    join person as author on revision.author = author.id
+    join person as committer on revision.committer = committer.id;
+$$;