This code recipe gives you an idea of how to use Flask-Admin with postgresql database.

from flask import Flask

from flask.ext.admin import Admin

from flask.ext.admin import BaseView

from flask.ext.admin import expose

from flask.ext.sqlalchemy import SQLAlchemy

from flask.ext.admin.contrib.sqla import ModelView

app = Flask(__name__)

app.config['SECRET_KEY'] = '123456790'

app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://postgres:postgres123@localhost/scrapy'

db = SQLAlchemy(app)

admin = Admin(app)

class MyView(BaseView):

    @expose('/')

    def index(self):

        return self.render('index.html')

class Cars(db.Model):

    can_create = False

    id = db.Column(db.Integer, primary_key=True)

    name = db.Column(db.String(64))

    price = db.Column(db.String(64))

admin.add_view(MyView(name='Hello'))

admin.add_view(ModelView(Cars, db.session))

if __name__ == '__main__':

    app.run(host='0.0.0.0',port=8080,debug=True)