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.14.tar.gz (51.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.14-py3-none-any.whl (51.9 MB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: overwatch_admin-0.1.14.tar.gz
  • Upload date:
  • Size: 51.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.14.tar.gz
Algorithm Hash digest
SHA256 e6f19b5032294cb7fe8e57c815e36364dfb0e58b88ea15f551c383f96cedb859
MD5 dc421bbab91abcd4f5e7969811c23143
BLAKE2b-256 eeb1ccf8b7bea2bf23f5638064f97e326a63337e52ae4acd8ef44474adc9b292

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for overwatch_admin-0.1.14-py3-none-any.whl
Algorithm Hash digest
SHA256 87346de37f2d351b32996b9e1c5d3f528d2232ab27ed912e83de0e665c357b8a
MD5 6ce53cb9faee9971cbb4900a038a040b
BLAKE2b-256 84a4f679555a5d10322a858a34cabef1790ab0293c9e4bbbb83a0dddfec21d3a

See more details on using hashes here.

Provenance

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