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.17.tar.gz (49.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.17-py3-none-any.whl (49.8 MB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: overwatch_admin-0.1.17.tar.gz
  • Upload date:
  • Size: 49.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.17.tar.gz
Algorithm Hash digest
SHA256 a2521dcc9de83c5f6038c795167214e9c2188905acdc56247fb7593043d372c9
MD5 1cf68e26d9822eac28a8abb3ee14545f
BLAKE2b-256 293d8efd9e0b4cdf515bb25e71a5512674f0e010d9ba2c443e00d088cb3e8447

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for overwatch_admin-0.1.17-py3-none-any.whl
Algorithm Hash digest
SHA256 e8f35980b0f30e8c920b3c2130791ec437badea1a52b71b7c7a3bf24bb78f5b8
MD5 e04c699864f17cd4871f7a40bdb778ad
BLAKE2b-256 0ddcdfd8035b8561b4f5a34c631e4bb028f538450314060cc329a3678d5f81cd

See more details on using hashes here.

Provenance

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