How to keep history of MySQL/Aurora stored procedure revisions?
Here's a good StackOverflow post with various answers that might help you: Put MySQL database under version control?
Specifically, Liquibase seems to withstood the test of time, and it seems to be supported by AWS (seeing as you mentioned Aurora): Deploy, track, and roll back RDS database code changes using open source tools Liquibase and Jenkins
(Note this leverages the Amazon service CodeCommit.)