Based on your situation, I can help you set up Prefect Server with PostgreSQL. Here's what you'll need to do: 1. First, you'll need a PostgreSQL database that's accessible from your IBM Cloud Code Engine environment. This could be: - IBM Cloud Databases for PostgreSQL - Any other managed PostgreSQL service - A self-hosted PostgreSQL instance (as long as it's network-accessible) 2. Once you have your PostgreSQL database ready, you'll need to modify your Code Engine project configuration to include the following environment variable:

PREFECT_API_DATABASE_CONNECTION_URL=<postgresql+asyncpg://username:password@host:5432/database_name>

Replace the following: - `username`: Your PostgreSQL username - `password`: Your PostgreSQL password - `host`: Your PostgreSQL host address - `database_name`: The name of the database you want Prefect to use 3. In your Code Engine project settings, add this environment variable. The exact steps would be: - Go to your Code Engine project - Select your Prefect Server application - Add the environment variable under the configuration section 4. Important considerations: - Ensure your PostgreSQL database is accessible from your Code Engine environment (check network/firewall rules) - The database user should have all necessary permissions to create and modify tables - It's recommended to use connection pooling if available in your PostgreSQL setup - Store sensitive information like passwords using Code Engine's secrets management 5. After setting this up, when you restart your Prefect Server, it will automatically: - Connect to the PostgreSQL database - Create all necessary tables if they don't exist - Start using PostgreSQL instead of SQLite This way, even if your Code Engine container restarts or goes down, all your Prefect data (flows, deployments, flow runs, etc.) will persist in the PostgreSQL database. A few tips: - Make sure to backup your PostgreSQL database regularly - Monitor your database connections and performance - Consider using connection pooling if you expect high concurrency - Use SSL connections if your database is hosted outside IBM Cloud Would you like me to provide more specific details about any of these steps or help with troubleshooting the setup?