Skip to main content

Admin panel for FastAPI applications with SQLAlchemy models

Project description

Overwatch - Admin Panel for FastAPI

Python FastAPI SQLAlchemy License

Overwatch is a reusable, admin panel package for FastAPI applications that automatically generates CRUD interfaces for SQLAlchemy models. It provides an Admin experience with enhanced features including audit logging, permissions, and a modern TypeScript frontend.

✨ Features

  • 🔧 Model Agnostic: Works with any SQLAlchemy model
  • 🎨 Modern UI: TypeScript frontend with Modern components
  • 🔐 Authentication: Secure JWT-based authentication system
  • 👥 Role Management: Hierarchical roles with fine-grained permissions
  • 📊 Audit Logging: Complete audit trail of all admin actions
  • 🔍 Search & Filter: Advanced search and filtering capabilities
  • 📄 Pagination: Efficient pagination for large datasets
  • 🚀 Performance: Async operations and optimized queries

🚀 Quick Start

Installation

pip install overwatch-admin

Basic Usage

from fastapi import FastAPI
from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from overwatch import OverwatchAdmin, OverwatchConfig

# Create FastAPI app
app = FastAPI()

# Define your models
Base = declarative_base()

class User(Base):
    __tablename__ = "users"

    id = Column(Integer, primary_key=True)
    username = Column(String(50), unique=True)
    email = Column(String(100))

# Initialize Overwatch admin
admin = OverwatchAdmin(
    app=app,
    db_session=get_db_session,  # Your database session dependency
    models=[User],  # Your SQLAlchemy models
    admin_title="My Admin Panel"
)

# Configure model display
admin.configure_model(
    User,
    list_fields=["id", "username", "email"],
    search_fields=["username", "email"],
)

app.run()

📋 Requirements

  • Python 3.11+
  • FastAPI 0.104+
  • SQLAlchemy 2.0+
  • Async database driver (asyncpg, aiosqlite, etc.)

⚙️ Configuration

Overwatch can be configured through environment variables or direct configuration:

from overwatch import OverwatchConfig
from overwatch.core.config import SecurityConfig

config = OverwatchConfig(
    admin_title="My Admin Panel",
    security=SecurityConfig(
        secret_key="your-secret-key",
        access_token_expire_minutes=30,
        password_min_length=8,
    ),
    per_page=25,
    enable_audit_log=True,
    enable_dashboard=True,
    cors_origins=["http://localhost:3000"],
)

Environment Variables

OVERWATCH_ADMIN_TITLE="My Admin Panel"
OVERWATCH_SECURITY__SECRET_KEY="your-secret-key"
OVERWATCH_SECURITY__ACCESS_TOKEN_EXPIRE_MINUTES=30
OVERWATCH_PER_PAGE=25
OVERWATCH_ENABLE_AUDIT_LOG=true

🔐 Authentication & Authorization

Built-in Authentication

Overwatch comes with a complete authentication system separate from your application's user system:

# Create admin user
admin = await admin.create_admin(
    username="superadmin",
    password="secure-password",
    email="admin@example.com",
    role="super_admin"
)

Roles & Permissions

  • Super Admin: Full access to all resources
  • Admin: Standard CRUD operations
  • Read Only: View-only access

🔧 Advanced Usage

Custom Database

Overwatch can use a separate database:

config = OverwatchConfig(
    database={
        "url": "postgresql+asyncpg://overwatch:password@localhost/overwatch_db",
        "echo": False
    }
)

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

🙏 Acknowledgments

  • FastAPI - The web framework that makes Overwatch possible
  • SQLAlchemy - Powerful ORM for database operations
  • Pydantic - Data validation and settings management

📞 Support


Overwatch - Making admin panels in FastAPI simple and beautiful. 🚀

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

overwatch_admin-0.1.16.tar.gz (57.3 MB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

overwatch_admin-0.1.16-py3-none-any.whl (57.9 MB view details)

Uploaded Python 3

File details

Details for the file overwatch_admin-0.1.16.tar.gz.

File metadata

  • Download URL: overwatch_admin-0.1.16.tar.gz
  • Upload date:
  • Size: 57.3 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.7

File hashes

Hashes for overwatch_admin-0.1.16.tar.gz
Algorithm Hash digest
SHA256 50caad811fc26bd27fda1c945f74c90b3683a7b7add97575328bcf48e6816217
MD5 cacfc6b2fc28dde356434e14926a09ca
BLAKE2b-256 18b4d535c12a95a918c2cfb15e930d715b0c8fcea584f883553b815e537f135d

See more details on using hashes here.

Provenance

The following attestation bundles were made for overwatch_admin-0.1.16.tar.gz:

Publisher: release.yml on u3n-ai/overwatch

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file overwatch_admin-0.1.16-py3-none-any.whl.

File metadata

File hashes

Hashes for overwatch_admin-0.1.16-py3-none-any.whl
Algorithm Hash digest
SHA256 204c7b0848ceeb96244ba3609d465e9e318e26ce5ea7b32632ed7a36c84b20bf
MD5 707d35b072fed3911bb462f110ea36a1
BLAKE2b-256 a98f63655f3b370c7438ea982ff5af88e5ae5eaef77787bafbf48f4a9c7a91ef

See more details on using hashes here.

Provenance

The following attestation bundles were made for overwatch_admin-0.1.16-py3-none-any.whl:

Publisher: release.yml on u3n-ai/overwatch

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page