Ana Sayfa / Kod ve Scriptler / AskDB AI – SQL Query Generator
AskDB AI – SQL Query Generator
skDB AI, doğal dili SQL'e dönüştüren modern bir PHP/CodeIgniter SaaS'tır; yerleşik kredi, faturalandırma ve tam bir yönetici
- Yayın tarihi16 Mart 2026
- Nerede çalışırPHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2, PHP 8.3, PHP 8.4
- Paket içeriği.php, .css, .html, .sql, JavaScript .js
- Son güncelleme16 Mart 2026

Overview
AskDB AI is a production‑ready, credit‑based SaaS application that lets your users query relational databases using plain English instead of SQL. Powered by OpenAI GPT models, it can generate, optimize, debug and execute SQL queries, create reports, build charts, and provide AI‑driven insights on top of your data. The platform includes a complete authentication system, user dashboard, credit packages, simulated billing flow, and a polished admin panel to monitor users, payments, queries, and API settings. Built on CodeIgniter 3 and Bootstrap 5, AskDB AI is easy to deploy on any standard LAMP stack and simple to customize or extend for client projects or white‑label SaaS offerings.
Features
- Natural language to SQL
- Convert user questions into executable SQL.
- Supports generation, optimization, and debugging of SQL queries.
- AI‑powered analytics
- Insights: generate SQL, execute it, and explain the results.
- Report generator: full report SQL from a description.
- Chat assistant for SQL help and explanations.
- Charts & ER diagrams
- Chart.js integration to visualize query results.
- ER diagram view from uploaded schema definitions.
- Credit‑based billing system
- Configurable credit packages (Starter, Pro, Business).
- Per‑feature credit usage (query, chat, insights, reports, optimizer, debugger).
- Simulated checkout flow ready to be wired to Stripe/PayPal.
- User management
- Email/password registration and login with bcrypt hashing.
- Free credits on registration (configurable).
- Query history, saved queries library, templates, and schema management.
- Block/unblock users from the admin panel.
- Admin panel
- Dashboard with key metrics (users, queries, revenue approximation, credits used).
- Manage users, payments, and recent queries.
- Settings page to configure OpenAI API key, model, and endpoint (including Azure/OpenAI‑compatible endpoints).
- Secure architecture
- Session‑based authentication (user and admin separated).
- CSRF protection, XSS escaping helpers, and prepared statements / Query Builder.
- API keys stored in the database
settingstable.
- Modern UI/UX
- Bootstrap 5.3 + Bootstrap Icons.
- Clean, responsive layouts for both user dashboard and admin panel.
- Extensible codebase
- CodeIgniter 3 MVC structure.
- Reusable OpenAI libraries for SQL, chat, insights, charts, and reports.
- Helper functions and hooks for centralized AI configuration and overrides.
Requirements
- Server requirements
- PHP 7.4+ (PHP 8.x recommended)
- MySQL 5.7+ or MariaDB 10.3+
- Apache (with
mod_rewrite) or Nginx equivalent - PHP extensions: cURL, JSON, MBString, OpenSSL
- Composer not required (classic CI3 project)
- Client requirements
- Modern browser (Chrome, Firefox, Edge, Safari)
- JavaScript enabled
- External services
- OpenAI API key (or compatible provider/Azure endpoint)
Benzer ürünler

DB Change Guard | Yanlışlıkla veri kaybını durdurun! Anlık geri alma ve tam denetim izi ile gerçek zamanlı veritabanı izleme.
Yayın: Şubat 2026
JSON tabanlı özelleştirme ve otomatik ilişki yönetimi içeren, tablo verilerini kopyalamak ve taşımak için güçlü SQL Server betiği.
Yayın: Haziran 2025
Uygulamalarınızı sıfırdan kodlayarak yüzlerce saat tasarruf edin; bunun yerine web uygulamanızı hazır hale getirin.
Yayın: Temmuz 2022
Veritabanı verileriniz için sayfalama, sıralama, filtreleme ve daha fazlasıyla kolayca tablolar oluşturun.
Yayın: Ekim 2021
Veritabanı Yönetimi CRUD
Yayın: Mayıs 2020
CodeIgniter Betiği
Yayın: Mart 2020