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.15.tar.gz (53.2 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.15-py3-none-any.whl (53.9 MB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: overwatch_admin-0.1.15.tar.gz
  • Upload date:
  • Size: 53.2 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.15.tar.gz
Algorithm Hash digest
SHA256 37c07e47b03e9cd7a43c5b909fde41c5edf386c0d97ef5a091be3f4bf121d882
MD5 7ecac8785a961bf3e0173a33e27955a8
BLAKE2b-256 ef5aa2ba2b49b6dacfa6bb467eb8f2e6d1886ffd9eb50bf10b7bd842af410772

See more details on using hashes here.

Provenance

The following attestation bundles were made for overwatch_admin-0.1.15.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.15-py3-none-any.whl.

File metadata

File hashes

Hashes for overwatch_admin-0.1.15-py3-none-any.whl
Algorithm Hash digest
SHA256 74b3b50b3fdeea8d8106c0151142ed361768bf2930a8d5127d432e9f9dec8cf2
MD5 dda8bcc3cbf5f62b8058d80767f9ea6a
BLAKE2b-256 e8fcb00b8a310fedf1c77c202fb7c5ba10d381d7a47d3b8d643fcc72c1f4398e

See more details on using hashes here.

Provenance

The following attestation bundles were made for overwatch_admin-0.1.15-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