Connect PostgreSQL Database to Metabase

I need a PostgreSQL database connected to our Metabase app.

Requirements:
- Direct connection
- Read and write access
- Handle general data

Ideal Skills:
- Experience with PostgreSQL and Metabase
- Familiarity with setting up direct database connections
- Knowledge of data access permissions and security

Please provide your relevant experience and approach.