Text2Base: AI Data Architect & SQL Manager 🧠💾
Design, Manage, and Query your Databases using Natural Language.
No SQL required. 100% Safe. Directly inside VS Code.
🚀 What is Text2Base?
Text2Base eliminates the friction between business logic and database implementation. Forget about writing complex SQL boilerplate or manually designing schemas.
Just chat with your database. Text2Base acts as your personal Database Architect and DBA, translating your natural language into precise, optimized, and safe database operations.
Supported Databases: MySQL, MariaDB, MongoDB.
(PostgreSQL & MSSQL coming soon)
✨ Key Features
1. 🗣️ Chat with your Database (Natural Language)
Write what you need, and let the AI do the rest.
- Intelligent Translation: "Show me active users who signed up last week" $\rightarrow$
SELECT * FROM users WHERE...
- Fuzzy Search Detection: The AI automatically detects when to use partial matching (
LIKE %...% or Regex) without you asking.
- Context Aware: The AI remembers your conversation history, allowing for a natural dialogue about your data.
- Multi-Language: Chat in English, Spanish, Portuguese, or your native language. The AI understands it all.
2. 🏗️ AI Database Architect
Design complex schemas from scratch by simply describing your business idea.
- Real-Time Visualization: Watch as Mermaid.js ER Diagrams are generated instantly while you describe your requirements.
- Auto-DDL Generation: Get production-ready
CREATE TABLE or db.createCollection scripts.
- One-Click Deploy: Apply the schema to your database immediately when you are satisfied.
- Proactive Schema: If you try to query a table that doesn't exist, the AI will offer to create it for you.
3. 🛡️ Safety First: The "No-Regret" Workflow
We know developers fear AI messing up their data. Text2Base is built for safety.
- Before & After Previews: Before any
UPDATE, DELETE, or INSERT, see a visual diff of exactly which rows/documents will be affected.
- 2-Step Confirmation: Destructive operations always require your explicit approval.
- Self-Healing AI: If the generated query fails, the AI analyzes the error message, fixes the query, and proposes a solution automatically.
4. ⚙️ AI Stored Procedure Architect (MySQL)
Stop struggling with PL/SQL syntax.
- Describe your logic (e.g., "Create a procedure to transfer money between accounts and log the transaction").
- Text2Base generates the complete
CREATE PROCEDURE script with parameters and internal logic.
5. 📊 Instant BI Reports
Turn raw data into actionable business insights.
- Ask: "Generate a sales report by category for Q4."
- Receive a detailed analysis in Markdown format, ready to copy-paste into your documentation or emails.
📸 See it in Action
⚡ Designing a Schema from Scratch
(Place a GIF here showing: User typing "Create a Netflix clone schema" -> ER Diagram appearing -> SQL Code generating)
🔍 Safe Data Updates
(Place a GIF here showing: User typing "Update prices" -> The "Before/After" preview table appearing -> User clicking Confirm)
🛠️ How to Use
- Install the extension.
- Click the Text2Base icon in the Activity Bar.
- Connect your database (MySQL, MariaDB, or MongoDB).
- Start chatting!
🔒 Security & Privacy
- Your Data stays yours. We do not train models on your database content.
- Metadata Sync: We only sync schema metadata (table names, columns) to give the AI context.
- Controlled Execution: No query is executed without your command.
📬 Support
Love Text2Base?
Please leave a ⭐⭐⭐⭐⭐ review! It helps us build more features.
