SQLAlchemy Setup in Python

From the Flask cheat sheet · Database Integration · verified Jul 2026

SQLAlchemy Setup

Integrate Flask with SQLAlchemy ORM

python

# Quick Reference
from flask_sqlalchemy import SQLAlchemy

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///app.db'
db = SQLAlchemy(app)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True)

💡 Use Flask-Migrate for database migrations

🔍 SQLAlchemy provides powerful ORM capabilities

⚡ Use lazy loading for relationships to optimize queries

📌 Always use app context when working with db outside request

databasesqlalchemy

Back to the full Flask cheat sheet