Platform Backend

The Platform Backend uses a multi-tenant PostgreSQL schema to support data modeling and authentication. The Platform Backend implements bearer token authentication for session management and user access. The Platform Backend integrates the DS-STAR FileAnalyzer for automatic cataloging of uploaded files. The Platform Backend extracts data into DuckDB tables for analysis and query execution. The Platform Backend implements a natural language query endpoint to generate and execute SQL queries from user questions. The Platform Backend is built as a FastAPI app exposing API endpoints for auth, projects, files, extraction, and analysis. The Platform Backend uses DS-STAR subprocess calls to implement cataloging, extraction, and SQL generation features. Ollama provides the qwen3-coder-next and nomic-embed-text models integrated into the Platform Backend for AI-powered text-to-SQL and document embedding. Qdrant is integrated into the Platform Backend for storage and retrieval of document vectors supporting Document RAG. The Platform Backend depends on Redis 7 for future background job management and caching, although it is not yet implemented. The Docker Compose Stack includes the Platform Backend service as one of its containers alongside PostgreSQL and Redis. Coolify is the deployment platform intended to host the Platform Backend service and its supporting infrastructure. The Platform Backend depends on DS-STAR FileAnalyzer to perform automatic cataloging immediately after file upload.