1-Click PostGIS

from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

# Replace with your connection URL
DATABASE_URL = "your_connection_url"

engine = create_engine(DATABASE_URL)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base = declarative_base()

1. Open QGIS and go to Layer > Add Layer > Add PostGIS Layers
2. Click New to create a new connection
3. Enter the connection details:
   • Name: Give your connection a name
   • Host: Enter the host from the connection details
   • Port: Enter the port from the connection details
   • Database: Enter the database name from the connection details
   • Username: Enter the username from the connection details
   • Password: Enter the password from the connection details
4. Click Test Connection to verify
5. Click OK to save the connection