What is Maniyam API v2?
Maniyam API v2 (Maniyam Enterprise Platform) is the next-generation backend powering the Maniyam AI-first Enterprise Business Suite. Built with FastAPI, async PostgreSQL, and enterprise-grade security, v2 introduces advanced features like AI-powered automation, real-time ETL processing, and comprehensive organizational management.
Core Technologies
- • FastAPI - High-performance async Python framework
- • SQLAlchemy 2.0 - Async ORM with PostgreSQL
- • Redis - Caching & rate limiting
- • Pydantic v2 - Data validation & serialization
- • JWT + OAuth2 - Enterprise authentication
Enterprise Features
- • Multi-tenancy - Complete data isolation
- • RBAC - Hierarchical permission system
- • Rate Limiting - Per-tenant request throttling
- • Audit Logging - Structured JSON logging
- • ETL Worker - Background data processing
Release 2026.2.1 Targets
Key features and modules targeted for the upcoming production release.
AI Agent Chatbot
In DevelopmentNatural language permission management with Intent Kernel AI orchestrator. Enables conversational HR operations.
Reporting Module (ETL)
Fixed 2026-02-03Real-time ETL with CDC triggers. Auto-updates 16 aggregation tables every 5 seconds. RCA completed and routing fix applied.
ATS with AI Resume
PartialEnd-to-end Applicant Tracking System with AI-powered resume screening, ranking, and candidate management.
Groups & Departments
Ready for ReleaseComplete organizational structure management with hierarchical departments, groups, and user assignments.
Accounting Module
Nice to HaveInvoicing, bills, payments, journals, and purchase orders. Complete financial management integration.
Reporting System
Phase 3 CompleteDynamic report builder with edit flows, dashboard management, live preview, and ETL-powered aggregations.
Production vs Development Status
Production (2026.1.1)
devv2.maniyam.com • Stable Release
Available Features
- Authentication & JWT Tokens
- Multi-tenant Architecture
- RBAC Permission System
- Dynamic Forms Engine
- CRM & Customer Management
- Departments & Groups (Basic)
- Leave Management
- Timesheet & Payroll
Development (2026.2.1)
release/2026.2.1 • Next Release
New & Enhanced Features
- Groups & Departments (Enhanced) NEW
- Soft Delete & Validation NEW
- User Assignments Module NEW
- Work Assignments NEW
- Assignment Types & Roles NEW
- ETL Background Worker NEW
- ATS Resume Screening WIP
- AI Chatbot Integration WIP
Database Migration Status
Migrations required to upgrade production from 2026.1.1 to 2026.2.1
| Migration | Description | Dev | Prod | Action |
|---|---|---|---|---|
| 001 | Cron Jobs Tables | ✓ Applied | ✓ Applied | None |
| 002 | Departments & Groups (Base) | ✓ Applied | ✓ Applied | None |
| 003 | Departments PRD Updates | ✓ Applied | ✓ Applied | None |
| 004 | Groups M2M Junction Table | ✓ Applied | ⚠ Partial | Run partial |
| 005 | Assignments Module | ✓ Applied | ✗ Missing | Run full |
| 006 | Assignment Types & Roles | ✓ Applied | ⚠ Partial | Run partial |
| 007 | Groups Dept Optional | ✓ Applied | ✗ Missing | Run full |
Consolidated Migration Available
A single consolidated migration script PROD_2026.2.1_CONSOLIDATED_MIGRATION.sql
is available that includes all missing migrations. Creates 9 new tables and updates FK constraints.
ETL & Reporting System
ACTIVEReal-time Change Data Capture (CDC) system with automatic aggregation updates.
How It Works (Auto-Trigger)
Recent Fix (2026-02-03): Routing logic updated to process all table types.
See Dox/reporting/RCA/ for full analysis.
Reporting System Phase 3
NEW 2026-02-05Complete Edit flows for Reports and Dashboards with Live Preview capability.
Edit Report Flow
CompleteFull edit capability for custom reports with pre-filled configuration.
- • Edit button on Report View page
- • Pre-fill name, description, SQL, chart type
- • PUT /reports/{id} for updates
Edit Dashboard Flow
CompleteFull edit capability for custom dashboards with pre-selected reports.
- • Edit button on Dashboard View page
- • Pre-fill name, description, selected reports
- • PUT /reports/dashboards/{id} for updates
Live Preview
CompletePreview report results without saving to database.
- • POST /reports/preview endpoint
- • Executes SQL without persisting
- • Returns data + column metadata
Phase 3 API Endpoints
PUT /v2/api/reports/{id}
Update existing report configuration
PUT /v2/api/reports/dashboards/{id}
Update existing dashboard
POST /v2/api/reports/preview
Preview report without saving
GET /v2/api/reports/dashboards/{id}
Get dashboard with report configs
JIRA: MNYM-357 • Branch: release/2026.2.1 • Status: Dev Complete
API Modules & Endpoints
Authentication
JWT tokens, OAuth2, refresh tokens, password reset
/v2/api/auth/*
Users & Permissions
User management, roles, hierarchical permissions
/v2/api/users/*
Departments
Hierarchical departments with soft delete
/v2/api/departments/*
Groups
Organizational groups with M2M departments
/v2/api/groups/*
Assignments
User-to-org assignments with roles
/v2/api/assignments/*
Forms Engine
Dynamic forms, templates, field relations
/v2/api/forms/*
CRM
Customers, vendors, mailbox
/v2/api/crm/*
ATS
Candidates, interviews, offers, onboarding
/v2/api/ats/*
Accounting
Invoices, bills, payments, journals
/v2/api/accounting/*
Appendix & Technical Details
Database Connections
Host: 52.91.125.253
Schema: maniyamnew
Host: maniyam-prod.*.rds.amazonaws.com
Schema: maniyamproddb