Best way to approach this problem?

I have a situation in which I am running the CockroachDB alongside my API in a Docker container. I use Docker Compose to stand up both my Cockroach and my API. I am trying to create a database using a SQL script as soon as CockroachDB starts, what is the best approach of doing this when using the CockroachDB container?

Hi @freetoplay,

this document may be helpful.

Additionally, you can issue SQL statements directly using the cockroach binary without entering the SQL shell.

The syntax for that is here.