[API] Flask REST API + PostgreSQL database schema

[Vishnu2707]

Objective

Build the Flask REST API and PostgreSQL database layer that serves
findings data to the frontend dashboard.

Tasks

• api/app.py — Flask app factory, blueprints, CORS, JWT middleware
• api/models/finding.py — Finding model + DatabaseManager class
• api/routes/findings.py — GET /api/findings, GET /api/findings/
• api/routes/scans.py — GET /api/scans, POST /api/scans/trigger
• api/routes/score.py — GET /api/score
• api/routes/compliance.py — GET /api/compliance/
• Deploy to Render free tier (render.com)
• Connect to PostgreSQL via Render free PostgreSQL instance

Database schema

findings (id, rule_id, severity, resource_id, resource_name, created_at, status)
rules (rule_id, name, severity, category, description, frameworks)
scans (id, subscription_id, started_at, completed_at, finding_count)

Acceptance Criteria

• All API routes return correct JSON
• JWT authentication working
• Deployed live on Render free tier
• Connected to PostgreSQL

Branch

feat/flask-api

Depends on

Issue #1 must be merged to dev first

[safidnadaf]

Good morning. @Vishnu2707

I would like to work on the Flask REST API and PostgreSQL database schema for issue #3

Could you please add me as a collaborator so I can get started?

Thank you
Safid

[Vishnu2707]

Added u now @safidnadaf

[Vishnu2707]

@safidnadaf , any expected date for completion?

[Vishnu2707]

The issue has been updated, please cross check!

[safidnadaf]

Hi @Vishnu2707 , I am actively working through the fixes. Expected completion by May 13th. Will keep the PR updated."