gcp-function.py

import os
from flask import current_app as app, jsonify
import sqlalchemy

db_user = os.environ.get('username')
db_pass = os.environ.get('password')
db_name = os.environ.get('name')
db_connection_name = os.environ.get('conn_name')

db = sqlalchemy.create_engine(
    sqlalchemy.engine.url.URL(
        drivername='mysql+pymysql',
        username=db_user,
        password=db_pass,
        database=db_name,
        query={
            'unix_socket': '/cloudsql/{}'.format(db_connection_name)
        }
    ),
)

def list(request):
    entries = []
    with db.connect() as conn:
        rows = conn.execute("SELECT * FROM entries").fetchall()
        for row in rows:
            entries.append(row[0])
            
    return jsonify(entries)

requirements.txt

flask_sqlalchemy
pymysql