Skip to main content

​
Welcome to OdontologyApp

OdontologyApp is a modern, full-featured dental clinic management system designed specifically for dental practices that need to manage multiple branches, complex workflows, and comprehensive patient care records.

​
What is OdontologyApp?

OdontologyApp is a SaaS dental clinic management platform that streamlines every aspect of running a dental practice, from patient registration and appointment scheduling to clinical records, odontograms, inventory management, and financial reporting. Built with modern web technologies, OdontologyApp provides a fast, reliable, and intuitive interface for administrators, doctors, and secretarial staff to collaborate efficiently and deliver exceptional patient care.

​
Who is it for?

OdontologyApp is designed for:

Dental Clinics

Single or multi-branch dental practices seeking comprehensive digital management

Dental Professionals

Dentists who need efficient access to patient records, odontograms, and treatment histories

Administrative Staff

Receptionists and administrators managing appointments, patient intake, and operations

​
Key Features

Patient Management

Complete patient profiles with medical history, contact information, allergies, blood type, and comprehensive anamnesis records

Appointment Scheduling

Advanced scheduling system with multi-doctor support, appointment status tracking (scheduled, confirmed, waiting, completed, cancelled), and duration management

Clinical Records

Detailed medical records including motif, diagnosis, treatment plans, future plans, and next visit scheduling

Digital Odontograms

Interactive odontogram management with tooth-by-tooth status tracking (healthy, caries, restored, extracted, crown, treatment)

Multi-Branch Support

Manage multiple clinic locations with branch-specific data, doctor assignments, and patient distribution

Role-Based Access Control

Granular permissions system with three primary roles (Admin, Doctor, Secretary) and customizable permission assignments

Inventory Management

Track dental supplies, monitor stock levels, and receive low-stock alerts

Financial Reporting

Track accounts receivable, monitor pending payments, and generate financial reports

Patient File Attachments

Upload and manage X-rays, treatment plans, consent forms, and other patient documents

Audit Logs

Comprehensive activity logging for security, compliance, and operational transparency

Medical Indications

Create and track medical indications and prescriptions for patients

Appointment Reminders

Automated reminder system for upcoming appointments (WhatsApp/Email integration ready)

​
Technology Stack

OdontologyApp is built with modern, production-ready technologies:

​
Frontend

  • SvelteKit 2.50.2 - Modern meta-framework for building high-performance web applications
  • Svelte 5.51.0 - Reactive component framework with minimal runtime overhead
  • Vite 7.3.1 - Lightning-fast build tool and development server
  • SvelteKit Superforms 2.30.0 - Form management with validation
  • Zod 4.3.6 - TypeScript-first schema validation
  • SweetAlert2 11.26.21 - Beautiful, responsive alerts and modals

​
Backend

  • SvelteKit Server Routes - API endpoints with server-side rendering
  • MySQL2 3.18.2 - MySQL database driver with connection pooling
  • bcryptjs 3.0.3 - Secure password hashing and authentication

​
Database

  • MySQL - Relational database with comprehensive schema including:
    • Branches, Users, Doctors, Patients
    • Appointments, Medical Records, Odontograms
    • Indications, Patient Files, Permissions
    • Audit Logs and System Activity

​
Architecture Overview

OdontologyApp follows a modern full-stack architecture:

​
Key Architectural Features

Session-Based Authentication: Uses secure HTTP-only cookies for session management with 24-hour token expiration
Connection Pooling: MySQL2 connection pool with 10 concurrent connections for optimal database performance
Stored Procedures: Database operations use stored procedures for security and performance (e.g., sp_authenticate_user, sp_create_log)
Server-Side Hooks: Request interceptor validates authentication and enforces role-based route protection

​
Permission System

OdontologyApp features a granular permission system with 43 distinct permissions across 7 modules:
  • Pacientes (Patients): VIEW, CREATE, EDIT, DELETE, PRINT
  • Citas (Appointments): VIEW, CREATE, EDIT, CANCEL
  • Clínico (Clinical): Medical records, odontograms, anamnesis, indications, attachments
  • Recordatorios (Reminders): VIEW, SEND
  • Inventario (Inventory): VIEW, MANAGE
  • Reportes (Reports): VIEW
  • Admin: Doctors, branches, users, logs, security, treatments, roadmap
Each user can have custom permission assignments, allowing for fine-grained access control beyond the standard role templates.

​
Default User Roles

​
Administrator

  • Full system access including user management, branch configuration, and system settings
  • Access to financial reports, inventory management, and audit logs
  • Can manage permissions for all users

​
Doctor

  • View and edit patients, manage medical records and odontograms
  • Access appointment schedule, create clinical notes
  • View and create medical indications
  • Upload patient files and attachments

​
Secretary

  • Create and manage patients, schedule appointments
  • Check-in/check-out patients
  • View (but not edit) medical records and odontograms
  • Send appointment reminders

​
Database Schema Highlights

The database includes 14 core tables with proper foreign key relationships:
  • branches - Multi-location clinic management
  • users - System users with role assignments
  • doctors - Extended doctor information with specialty and license
  • doctor_branches - Many-to-many relationship for doctor-branch assignments
  • patients - Comprehensive patient profiles with UUID for secure URLs
  • appointments - Appointment scheduling with status workflow
  • medical_records - Clinical visit documentation
  • odontograms - Tooth-by-tooth dental status tracking
  • indications - Medical prescriptions and recommendations
  • patient_files - Attachment management
  • permissions - Permission catalog
  • user_permissions - User-specific permission grants
  • logs - System audit trail

​
Next Steps

Quickstart Guide

Get up and running in minutes with our quickstart guide

Installation

Detailed installation instructions for production deployment

Build docs developers (and LLMs) love

Get started for freeTalk to us