Can I use a custom SQL database with Corda in production?

Yes. Corda ships with H2 as an internal database but you can customize it to support tools like Azure SQL, SQL Server, Oracle, and PostgreSQL. Here’s our documentation on how to configure it.

You may also want to look at this recent blog post on CorDapp development from a database perspective.