Telegram bot for massage salon

I implemented a fully functional Telegram bot for a massage salon that automates the process of booking clients and managing the schedule. The bot provides a convenient and quick booking without the involvement of an administrator.

Main features:

- Checking available time slots — the user can view free hours for booking in real-time.
- Appointment booking — the bot processes reservations and adds them to the database.
- Reminder before the appointment — automatic notification 1 hour before the visit.
- Cancellation of booking — the client can easily cancel the reservation through the bot.

Technology stack:
Python — main logic of the project
Aiogram — implementation of the Telegram bot
PostgreSQL — storage of data about bookings and clients
SQLAlchemy — ORM for convenient database interaction
APScheduler — scheduling reminders and background tasks

Infrastructure:

Hosting on VPS — complete setup and deployment of the project on a dedicated server, environment configuration, ensuring stable operation of the bot 24/7.

The bot is developed with a focus on stability, security, and scalability. It is suitable for both small salons and a network of establishments.