diff --git a/sql/upgrades/113.sql b/sql/upgrades/113.sql
new file mode 100644
index 00000000..9a1d1762
--- /dev/null
+++ b/sql/upgrades/113.sql
@@ -0,0 +1,33 @@
+-- SWH DB schema upgrade
+-- from_version: 112
+-- to_version: 113
+-- description: Open indexer_configuration_add endpoint
+
+insert into dbversion(version, release, description)
+      values(113, now(), 'Work In Progress');
+
+CREATE OR REPLACE FUNCTION swh_indexer_configuration_add() RETURNS SETOF indexer_configuration
+    LANGUAGE plpgsql
+    AS $$
+begin
+      insert into indexer_configuration(tool_name, tool_version, tool_configuration)
+      select tool_name, tool_version, tool_configuration from tmp_indexer_configuration tmp
+      on conflict(tool_name, tool_version, tool_configuration) do nothing;
+
+      return query
+          select id, tool_name, tool_version, tool_configuration
+          from tmp_indexer_configuration join indexer_configuration
+              using(tool_name, tool_version, tool_configuration);
+
+      return;
+end
+$$;
+
+CREATE OR REPLACE FUNCTION swh_mktemp_indexer_configuration() RETURNS void
+    LANGUAGE sql
+    AS $$
+    create temporary table tmp_indexer_configuration (
+      like indexer_configuration including defaults
+    ) on commit drop;
+    alter table tmp_indexer_configuration drop column id;
+$$;