diff --git a/db/post_migrate/20250729125313_remove_issues_on_duplicated_id_index.rb b/db/post_migrate/20250729125313_remove_issues_on_duplicated_id_index.rb
new file mode 100644
index 0000000000000000000000000000000000000000..c57dfbdd3fdb23dc116d1cbe38cff6b401b28653
--- /dev/null
+++ b/db/post_migrate/20250729125313_remove_issues_on_duplicated_id_index.rb
@@ -0,0 +1,16 @@
+# frozen_string_literal: true
+
+class RemoveIssuesOnDuplicatedIdIndex < Gitlab::Database::Migration[2.3]
+  milestone '18.3'
+
+  INDEX_NAME = 'index_issues_on_duplicated_to_id'
+
+  # Index to be destroyed synchronously in https://gitlab.com/gitlab-org/gitlab/-/issues/557893
+  def up
+    prepare_async_index_removal :issues, :duplicated_to_id, name: INDEX_NAME
+  end
+
+  def down
+    unprepare_async_index :issues, :duplicated_to_id, name: INDEX_NAME
+  end
+end
diff --git a/db/schema_migrations/20250729125313 b/db/schema_migrations/20250729125313
new file mode 100644
index 0000000000000000000000000000000000000000..d68a130a8e3875ea33b48895b800e69265918942
--- /dev/null
+++ b/db/schema_migrations/20250729125313
@@ -0,0 +1 @@
+abc052dcc0be269a28a8aead1228bcd5441d647715b48298e2da5ea0d526eae3
\ No newline at end of file