SQL-Sensi

README

SQL-Sensi

SQL-Sensi is a Telegram bot designed to help users learn and practice MySQL. It provides an interactive platform where users can connect to a database, execute SQL commands, and share tables with other users. The bot also offers sample tables and data to help users get started quickly.

Features

Here's what SQL-Sensi currently offers and what's coming soon:

Currently Available ✅

• Direct Database Connection: Connect directly to your MySQL database with secure credentials
• SQL Command Execution: Run SQL queries directly through Telegram with support for all major SQL operations
• Sample Data: Pre-built tables and sample data for practice and learning
• AI Assistance: Get help from AI to solve MySQL problems and generate queries
• Command Reference: Comprehensive help system listing all available commands and their usage
• Interactive Learning: Practice SQL with immediate feedback and results

Coming Soon 🚧

• Enhanced Table Sharing: Share your tables and data structures with other users for collaborative learning
• Query Templates: Pre-built query templates for common database operations
• Query History: Track and revisit your previously executed queries
• Performance Analytics: Get insights into your query performance and optimization suggestions
• Custom Datasets: Import your own datasets for practice
• Interactive Tutorials: Step-by-step SQL learning modules with hands-on exercises

Build and run

Direct download

[!NOTE] 📍You can directly download the linux binary from releases

🐧 Linux Binary: sql.sensi

🗜️ Linux Binary (7-Zipped): sql.sensi.7z

Prerequisites

• Go compiler installed

Download the source code

git clone https://github.com/Advik-B/SQL-Sensi.git
cd sql-sensi

Build the bot

go build -gcflags="all=-l -B" -ldflags="-s -w -extldflags '-static'" -trimpath -o sql.sensi

Setup Enviroment variables in a .env file or directly thru the environment

Variable Name	Description	Importance
DB_HOST	The mysql database host	REQUIRED
DB_USER	The mysql database user to connect with	REQUIRED
DB_PASS	The mysql database password	REQUIRED
TELEGRAM_API_KEY	The telegram bot token	REQUIRED
GEMINI_API_KEY	The Gemini API key for ai features	OPTIONAL

And run the bot

./sql.sensi