107 docs tagged with "database"

Answer questions about CODITECT, the codebase, or any topic by intelligently combining LLM reasoning with local knowledge base searches.

Full-featured SaaS financial model engine backed by SQLite (ADR-177). Create scenarios, edit assumptions (pricing, growth, funding, headcount, expenses), build outputs in 4 formats (static XLSX, formula XLSX, JSON, CSV), compare scenarios side-by-side, and maintain a complete audit trail.

Current Structure Analysis

Status

1.1 Purpose

1.1 Purpose

10.1 Side Drawer Design

10.1 Side Drawer Design

Overview

Overview

7.1 Gantt Visualization

7.1 Gantt Visualization

9.1 Advanced Multi-Select Filtering

9.1 Advanced Multi-Select Filtering

Version: 2.0

Version: 2.0

11. Message Queue Integration Patterns

Custom REST sync replaces PowerSync due to FSL license restrictions and operational simplicity

Team and project-level context backup and synchronization extending ADR-044

Status: Accepted

Status: Accepted

Status

Status: Accepted

Status

Document Specification Block

Date: 2025-10-06

| Field | Value |

ADR-015: Vector Embedding Dimension Strategy

Document Specification Block

Request Details

Status

Status

Status

Status

Status

Status

Status

Status: Accepted SUPERSEDED

Comprehensive guide for AI agents to effectively query, learn from, and contribute to the Coditect development knowledge base.

Proven patterns and strategies for AI agents to effectively leverage the Coditect knowledge base in their workflows.

Alert Management Implementation

Status

Date: December 22, 2025

Diagram Level: 2 (Container)

Diagram Level: 3 (Component)

Diagram Level: 4 (Code)

Purpose: Code call graph analysis for impact assessment and code navigation

Fast setup guide for running Celery workers and beat scheduler locally and in production.

Governance: ADR-053, ADR-118

Current Implementation Status

Overview

Governance: ADR-148, ADR-118

Governance: ADR-118, ADR-148

Governance: ADR-118

Governance: ADR-118, ADR-119

Expert agent specializing in CODITECT component database management, including indexing, searching, validation, integrity checks, and maintenance operations.

Export CODITECT component data from the database in various formats for backup, migration, analysis, or integration.

Rebuild or update the CODITECT component index database. Supports full rebuild, incremental updates, and FTS maintenance.

Search the CODITECT component database with full-text search, type filters, and advanced query options.

Generated: December 29, 2025

Generated: December 29, 2025

Migrate data between systems/databases including extraction, transformation, validation, incremental sync, and cutover planning.

Optimize data pipeline and query performance including indexing, partitioning, caching, query tuning, and infrastructure scaling.

Executive Summary

Executive Summary

Optimize database queries and schema for performance

Optimize database queries and schema for performance

1. Core Database Functions

Version: 2.0.0

1. Core Schema Structure

Purpose

1. Core System Requirements Analysis

Status

Comprehensive donor database management with segmentation, giving history, and relationship tracking

Core Application Files

FoundationDB specialist for CODITECT v4. Expert in multi-tenant key design, transaction patterns, performance optimization, and distributed consistency. Ensures ADR-001 compliance for data isolation and implements efficient query patterns.

ADRs: ADR-118, ADR-119

This guide explains how to use the HTTP mock infrastructure for testing API integrations in the Runway Calculator application.

Issue Summary

Date: December 22, 2025

Status: Accepted

Rust implementation specialist for CODITECT v4. Develops production-grade Rust code following ADR standards, with expertise in Actix-web, FoundationDB integration, async patterns, and multi-tenant architectures. Primary agent for src/ implementation.

FoundationDB schema design specialist for CODITECT v4. Ensures optimal key design for multi-tenant isolation, implements efficient transaction patterns, manages data consistency, and enforces ADR-006 data model standards. Expert in distributed key-value architecture.

1. What Must Be Preserved

Comprehensive member database with family relationships, attendance tracking, and pastoral care notes

Analysis Date: 2025-11-27

Analysis Date: 2025-11-27

Purpose: Inter-session coordination for multi-LLM environments

1. Core Monitoring Framework

Status

MEMORY-CONTEXT Dashboard

📊 QA REVIEW BLOCK - FINAL APPROVAL

Database schema version control, migration generation, rollback capability, and schema documentation for evolving data models.

Purpose: Automatic subscription renewal via Stripe with invoice payment, license extension, and email notifications.

Purpose: 14-day Pro trial activation workflow with validation, activation, and conversion tracking.

Status

Status

Status

Purpose and Importance

Natural language to SQL query conversion and optimization

Part 4: Data Architecture

Part 4.1: Detailed Data Flow Diagrams

V2 PROJECT PLAN CONSOLIDATION - Flow Diagram Current State (6 Files) Target State (3 Files + 1 Archive) Agent Orchestration Timeline

Date: December 17, 2025

1. Current System Extension Points

Priority Phase 1D - Security & Operations | Effort: 12 hours

Priority Phase 1D - Security & Operations | Effort: 12 hours