aiqwal


Nameaiqwal JSON
Version 1.0.0 PyPI version JSON
download
home_pagehttps://github.com/shivnathtathe/aiqwal
SummaryAI Query Writer for Any Language - Universal SQL generator that works with ANY database
upload_time2025-08-20 09:20:23
maintainerNone
docs_urlNone
authorShivnath tathe
requires_python>=3.8
licenseNone
keywords ai sql database natural-language llm sqlalchemy query-generator
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # AIQWAL - AI Query Writer for Any Language

๐ŸŒ **Universal AI-powered SQL generator that works with ANY database in the world!**

[![PyPI version](https://badge.fury.io/py/aiqwal.svg)](https://badge.fury.io/py/aiqwal)
[![Python versions](https://img.shields.io/pypi/pyversions/aiqwal.svg)](https://pypi.org/project/aiqwal/)
[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT)
[![Downloads](https://pepy.tech/badge/aiqwal)](https://pepy.tech/project/aiqwal)

## ๐Ÿš€ What is AIQWAL?

AIQWAL (AI Query Writer for Any Language) is a revolutionary Python library that converts natural language questions into SQL queries using AI, then executes them on **ANY database in the world**.

### โœจ Key Features

- ๐Ÿค– **AI-Powered**: Uses advanced language models.
- ๐ŸŒ **Universal Database Support**: Works with 15+ database types
- ๐Ÿ”„ **Auto-Adaptation**: Automatically converts SQL syntax for each database
- ๐Ÿ›ก๏ธ **Smart Validation**: Prevents dangerous operations and validates queries
- ๐ŸŽฏ **Zero Configuration**: Just provide a connection string!
- โšก **Production Ready**: Comprehensive error handling and logging

### ๐ŸŽฏ Supported Databases

| Database | Status | Connection Example |
|----------|--------|-------------------|
| **SQLite** | โœ… | `sqlite:///database.db` |
| **PostgreSQL** | โœ… | `postgresql://user:pass@host:5432/db` |
| **MySQL** | โœ… | `mysql://user:pass@host:3306/db` |
| **SQL Server** | โœ… | `mssql+pyodbc://user:pass@host/db` |
| **Oracle** | โœ… | `oracle+cx_oracle://user:pass@host:1521/db` |
| **Snowflake** | โœ… | `snowflake://user:pass@account/db` |
| **BigQuery** | โœ… | `bigquery://project/dataset` |
| **Redshift** | โœ… | `redshift+psycopg2://user:pass@host/db` |
| **MongoDB** | โœ… | `mongodb://host/db` (via SQL interface) |
| **Any SQLAlchemy DB** | โœ… | Any valid SQLAlchemy connection string |

## ๐Ÿ”ง Installation

```bash
# Basic installation
pip install aiqwal

# With all database drivers
pip install aiqwal[all]

# Development installation  
pip install aiqwal[dev]
```

### Prerequisites

1. **AI Model**: Download a compatible model (e.g., SQLCoder):
```bash
# Download SQLCoder model (recommended)
python -c "
import requests
url = 'https://huggingface.co/defog/sqlcoder-7b-2/resolve/main/sqlcoder-7b-q4_k_m.gguf'
response = requests.get(url)
with open('sqlcoder-7b-q4_k_m.gguf', 'wb') as f:
    f.write(response.content)
"
```

2. **Database Drivers**: Install drivers for your databases:
```bash
# PostgreSQL
pip install psycopg2-binary

# MySQL  
pip install pymysql

# SQL Server
pip install pyodbc

# Oracle
pip install cx-oracle

# Snowflake
pip install snowflake-sqlalchemy

# BigQuery
pip install pybigquery
```

## ๐Ÿš€ Quick Start

### Basic Usage

```python
from aiqwal import AIQWAL

# Connect to any database (SQLite example)
ai = AIQWAL('sqlite:///employees.db')

# Ask questions in natural language!
results = ai.query("Show me the top 10 highest paid employees")
print(results)
# [{'name': 'John Doe', 'salary': 95000}, ...]

# Works with complex queries too
results = ai.query("Find average salary by department for employees hired after 2020")
print(results)
```

### Different Databases

```python
# PostgreSQL
ai = AIQWAL('postgresql://user:password@localhost:5432/company')
results = ai.query("Show me monthly sales trends")

# MySQL
ai = AIQWAL('mysql://user:password@localhost:3306/ecommerce') 
results = ai.query("Find top selling products this quarter")

# SQL Server
ai = AIQWAL('mssql+pyodbc://user:password@server/database')
results = ai.query("Get customer retention rates by region")

# Snowflake
ai = AIQWAL('snowflake://user:password@account/database/schema')
results = ai.query("Analyze user engagement metrics")

# The same code works with ANY database!
```

### Advanced Usage

```python
from aiqwal import AIQWAL

# Initialize with custom model
ai = AIQWAL(
    connection_string='postgresql://user:pass@host/db',
    model_path='/path/to/your/model.gguf',
    auto_connect=True
)

# Generate SQL without executing (for review)
sql = ai.generate_sql_only("Find customers who haven't ordered in 30 days")
print(f"Generated SQL: {sql}")

# Execute raw SQL
results = ai.execute_sql("SELECT COUNT(*) FROM orders WHERE date > '2024-01-01'")

# Get database information
info = ai.get_database_info()
print(f"Connected to: {info['name']}")

# Get schema
schema = ai.get_schema()
print(f"Available tables: {list(schema.keys())}")
```

### CLI Usage

```bash
# Interactive mode
aiqwal interactive --db "postgresql://user:pass@host/db"

# Single query
aiqwal query --db "sqlite:///mydb.db" --query "Show top 10 sales"

# Generate SQL only
aiqwal generate --db "mysql://user:pass@host/db" --query "Find active users"
```

## ๐ŸŽฏ Real-World Examples

### E-commerce Analytics
```python
ai = AIQWAL('postgresql://user:pass@host/ecommerce_db')

# Sales analysis
sales = ai.query("Show monthly revenue trends for the last 12 months")

# Customer insights  
customers = ai.query("Find top 20 customers by total purchase value")

# Product performance
products = ai.query("Which products have the highest return rates?")
```

### HR Analytics
```python
ai = AIQWAL('mysql://user:pass@host/hr_system')

# Employee metrics
employees = ai.query("Show average salary by department and experience level")

# Hiring analysis
hiring = ai.query("What's our hiring trend by month for the last 2 years?")

# Retention insights
retention = ai.query("Calculate employee turnover rate by department")
```

### Financial Reporting
```python
ai = AIQWAL('mssql+pyodbc://user:pass@server/financial_db')

# Revenue analysis
revenue = ai.query("Break down revenue by product line and quarter")

# Expense tracking
expenses = ai.query("Show top expense categories for this fiscal year")

# Profitability
profit = ai.query("Calculate profit margins by business unit")
```

## ๐Ÿ”ง Configuration

### Model Configuration
```python
# Use different AI models
ai = AIQWAL(
    connection_string='your-db-connection',
    model_path='/path/to/codellama-sql.gguf',  # CodeLlama
    # model_path='/path/to/wizardcoder-sql.gguf',  # WizardCoder
)
```

### Database-Specific Options
```python
# SQL Server with specific driver
ai = AIQWAL(
    'mssql+pyodbc://user:pass@server/db?driver=ODBC+Driver+17+for+SQL+Server',
    auto_connect=True
)

# PostgreSQL with SSL
ai = AIQWAL(
    'postgresql://user:pass@host:5432/db?sslmode=require',
    auto_connect=True  
)
```

## ๐Ÿ›ก๏ธ Security & Safety

AIQWAL includes built-in safety features:

- **Query Validation**: Prevents dangerous operations (DROP, DELETE, etc.)
- **SQL Injection Protection**: Uses parameterized queries
- **Schema Validation**: Ensures queries reference valid tables/columns
- **Connection Security**: Supports SSL/TLS for database connections

```python
# These will be safely rejected:
ai.query("DROP TABLE users")  # โŒ Dangerous operation blocked
ai.query("DELETE FROM orders")  # โŒ Modification blocked  
ai.query("Show me customers")  # โœ… Safe SELECT query allowed
```

## ๐Ÿงช Testing

```bash
# Run all tests
pytest

# Test specific database
pytest tests/test_postgresql.py

# Test with coverage
pytest --cov=aiqwal tests/

# Integration tests
pytest tests/test_integration.py
```

## ๐Ÿ“Š Performance

AIQWAL is designed for production use:

- **Model Loading**: 2-5 seconds (cached after first use)
- **Query Generation**: 1-10 seconds (depending on complexity)  
- **Query Execution**: Database-dependent
- **Memory Usage**: ~500MB-2GB (model-dependent)

### Benchmarks

| Database | Connection Time | Query Generation | Simple Query | Complex Query |
|----------|----------------|------------------|--------------|---------------|
| SQLite | <100ms | 2-5s | <100ms | 100-500ms |
| PostgreSQL | 100-300ms | 2-5s | 50-200ms | 200-1s |
| MySQL | 100-300ms | 2-5s | 50-200ms | 200-1s |
| SQL Server | 200-500ms | 2-5s | 100-300ms | 300-2s |

## ๐Ÿค Contributing

We welcome contributions! Please see our [Contributing Guide](CONTRIBUTING.md).

### Development Setup
```bash
# Clone repository
git clone https://github.com/yourusername/aiqwal.git
cd aiqwal

# Create virtual environment
python -m venv venv
source venv/bin/activate  # Linux/Mac
# venv\Scripts\activate   # Windows

# Install development dependencies
pip install -e .[dev]

# Run tests
pytest
```

## ๐Ÿ“š Documentation

- [Full Documentation](https://aiqwal.readthedocs.io/)
- [API Reference](https://aiqwal.readthedocs.io/en/latest/api/)
- [Database Support](https://aiqwal.readthedocs.io/en/latest/databases/)
- [Examples](https://aiqwal.readthedocs.io/en/latest/examples/)

## ๐Ÿ› Troubleshooting

### Common Issues

**Model Loading Error:**
```python
# Ensure model file exists and is compatible
import os
print(os.path.exists('path/to/model.gguf'))
```

**Database Connection Error:**
```python  
# Test connection string
ai = AIQWAL('your-connection-string')
print(ai.test_connection())
```

**Query Generation Issues:**
```python
# Check database schema
schema = ai.get_schema()
print("Available tables:", list(schema.keys()))
```

### Getting Help

- ๐Ÿ“š [Documentation](https://aiqwal.readthedocs.io/)
- ๐Ÿ› [Issue Tracker](https://github.com/yourusername/aiqwal/issues)
- ๐Ÿ’ฌ [Discussions](https://github.com/yourusername/aiqwal/discussions)
- ๐Ÿ“ง [Email Support](mailto:support@aiqwal.com)

## ๐Ÿ“„ License

AIQWAL is licensed under the MIT License. See [LICENSE](LICENSE) for details.

## ๐Ÿ™ Acknowledgments

- [SQLCoder](https://github.com/defog-ai/sqlcoder) for the excellent SQL generation model
- [llama.cpp](https://github.com/ggerganov/llama.cpp) for efficient model inference
- [SQLAlchemy](https://www.sqlalchemy.org/) for universal database connectivity
- The open-source community for continuous inspiration

## โญ Star History

If you find AIQWAL useful, please consider starring the repository!

[![Star History Chart](https://api.star-history.com/svg?repos=yourusername/aiqwal&type=Date)](https://star-history.com/#yourusername/aiqwal&Date)

---

**Made with โค๏ธ by the AIQWAL team**

*Transform natural language into SQL queries for ANY database in the world!*

            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/shivnathtathe/aiqwal",
    "name": "aiqwal",
    "maintainer": null,
    "docs_url": null,
    "requires_python": ">=3.8",
    "maintainer_email": null,
    "keywords": "ai sql database natural-language llm sqlalchemy query-generator",
    "author": "Shivnath tathe",
    "author_email": "sptathe2001@gmail.com",
    "download_url": "https://files.pythonhosted.org/packages/20/09/1487cf9c2a7d0b8805c8009585018f4dedd737c490310be5ec497ec2e366/aiqwal-1.0.0.tar.gz",
    "platform": null,
    "description": "# AIQWAL - AI Query Writer for Any Language\r\n\r\n\ud83c\udf0d **Universal AI-powered SQL generator that works with ANY database in the world!**\r\n\r\n[![PyPI version](https://badge.fury.io/py/aiqwal.svg)](https://badge.fury.io/py/aiqwal)\r\n[![Python versions](https://img.shields.io/pypi/pyversions/aiqwal.svg)](https://pypi.org/project/aiqwal/)\r\n[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT)\r\n[![Downloads](https://pepy.tech/badge/aiqwal)](https://pepy.tech/project/aiqwal)\r\n\r\n## \ud83d\ude80 What is AIQWAL?\r\n\r\nAIQWAL (AI Query Writer for Any Language) is a revolutionary Python library that converts natural language questions into SQL queries using AI, then executes them on **ANY database in the world**.\r\n\r\n### \u2728 Key Features\r\n\r\n- \ud83e\udd16 **AI-Powered**: Uses advanced language models.\r\n- \ud83c\udf0d **Universal Database Support**: Works with 15+ database types\r\n- \ud83d\udd04 **Auto-Adaptation**: Automatically converts SQL syntax for each database\r\n- \ud83d\udee1\ufe0f **Smart Validation**: Prevents dangerous operations and validates queries\r\n- \ud83c\udfaf **Zero Configuration**: Just provide a connection string!\r\n- \u26a1 **Production Ready**: Comprehensive error handling and logging\r\n\r\n### \ud83c\udfaf Supported Databases\r\n\r\n| Database | Status | Connection Example |\r\n|----------|--------|-------------------|\r\n| **SQLite** | \u2705 | `sqlite:///database.db` |\r\n| **PostgreSQL** | \u2705 | `postgresql://user:pass@host:5432/db` |\r\n| **MySQL** | \u2705 | `mysql://user:pass@host:3306/db` |\r\n| **SQL Server** | \u2705 | `mssql+pyodbc://user:pass@host/db` |\r\n| **Oracle** | \u2705 | `oracle+cx_oracle://user:pass@host:1521/db` |\r\n| **Snowflake** | \u2705 | `snowflake://user:pass@account/db` |\r\n| **BigQuery** | \u2705 | `bigquery://project/dataset` |\r\n| **Redshift** | \u2705 | `redshift+psycopg2://user:pass@host/db` |\r\n| **MongoDB** | \u2705 | `mongodb://host/db` (via SQL interface) |\r\n| **Any SQLAlchemy DB** | \u2705 | Any valid SQLAlchemy connection string |\r\n\r\n## \ud83d\udd27 Installation\r\n\r\n```bash\r\n# Basic installation\r\npip install aiqwal\r\n\r\n# With all database drivers\r\npip install aiqwal[all]\r\n\r\n# Development installation  \r\npip install aiqwal[dev]\r\n```\r\n\r\n### Prerequisites\r\n\r\n1. **AI Model**: Download a compatible model (e.g., SQLCoder):\r\n```bash\r\n# Download SQLCoder model (recommended)\r\npython -c \"\r\nimport requests\r\nurl = 'https://huggingface.co/defog/sqlcoder-7b-2/resolve/main/sqlcoder-7b-q4_k_m.gguf'\r\nresponse = requests.get(url)\r\nwith open('sqlcoder-7b-q4_k_m.gguf', 'wb') as f:\r\n    f.write(response.content)\r\n\"\r\n```\r\n\r\n2. **Database Drivers**: Install drivers for your databases:\r\n```bash\r\n# PostgreSQL\r\npip install psycopg2-binary\r\n\r\n# MySQL  \r\npip install pymysql\r\n\r\n# SQL Server\r\npip install pyodbc\r\n\r\n# Oracle\r\npip install cx-oracle\r\n\r\n# Snowflake\r\npip install snowflake-sqlalchemy\r\n\r\n# BigQuery\r\npip install pybigquery\r\n```\r\n\r\n## \ud83d\ude80 Quick Start\r\n\r\n### Basic Usage\r\n\r\n```python\r\nfrom aiqwal import AIQWAL\r\n\r\n# Connect to any database (SQLite example)\r\nai = AIQWAL('sqlite:///employees.db')\r\n\r\n# Ask questions in natural language!\r\nresults = ai.query(\"Show me the top 10 highest paid employees\")\r\nprint(results)\r\n# [{'name': 'John Doe', 'salary': 95000}, ...]\r\n\r\n# Works with complex queries too\r\nresults = ai.query(\"Find average salary by department for employees hired after 2020\")\r\nprint(results)\r\n```\r\n\r\n### Different Databases\r\n\r\n```python\r\n# PostgreSQL\r\nai = AIQWAL('postgresql://user:password@localhost:5432/company')\r\nresults = ai.query(\"Show me monthly sales trends\")\r\n\r\n# MySQL\r\nai = AIQWAL('mysql://user:password@localhost:3306/ecommerce') \r\nresults = ai.query(\"Find top selling products this quarter\")\r\n\r\n# SQL Server\r\nai = AIQWAL('mssql+pyodbc://user:password@server/database')\r\nresults = ai.query(\"Get customer retention rates by region\")\r\n\r\n# Snowflake\r\nai = AIQWAL('snowflake://user:password@account/database/schema')\r\nresults = ai.query(\"Analyze user engagement metrics\")\r\n\r\n# The same code works with ANY database!\r\n```\r\n\r\n### Advanced Usage\r\n\r\n```python\r\nfrom aiqwal import AIQWAL\r\n\r\n# Initialize with custom model\r\nai = AIQWAL(\r\n    connection_string='postgresql://user:pass@host/db',\r\n    model_path='/path/to/your/model.gguf',\r\n    auto_connect=True\r\n)\r\n\r\n# Generate SQL without executing (for review)\r\nsql = ai.generate_sql_only(\"Find customers who haven't ordered in 30 days\")\r\nprint(f\"Generated SQL: {sql}\")\r\n\r\n# Execute raw SQL\r\nresults = ai.execute_sql(\"SELECT COUNT(*) FROM orders WHERE date > '2024-01-01'\")\r\n\r\n# Get database information\r\ninfo = ai.get_database_info()\r\nprint(f\"Connected to: {info['name']}\")\r\n\r\n# Get schema\r\nschema = ai.get_schema()\r\nprint(f\"Available tables: {list(schema.keys())}\")\r\n```\r\n\r\n### CLI Usage\r\n\r\n```bash\r\n# Interactive mode\r\naiqwal interactive --db \"postgresql://user:pass@host/db\"\r\n\r\n# Single query\r\naiqwal query --db \"sqlite:///mydb.db\" --query \"Show top 10 sales\"\r\n\r\n# Generate SQL only\r\naiqwal generate --db \"mysql://user:pass@host/db\" --query \"Find active users\"\r\n```\r\n\r\n## \ud83c\udfaf Real-World Examples\r\n\r\n### E-commerce Analytics\r\n```python\r\nai = AIQWAL('postgresql://user:pass@host/ecommerce_db')\r\n\r\n# Sales analysis\r\nsales = ai.query(\"Show monthly revenue trends for the last 12 months\")\r\n\r\n# Customer insights  \r\ncustomers = ai.query(\"Find top 20 customers by total purchase value\")\r\n\r\n# Product performance\r\nproducts = ai.query(\"Which products have the highest return rates?\")\r\n```\r\n\r\n### HR Analytics\r\n```python\r\nai = AIQWAL('mysql://user:pass@host/hr_system')\r\n\r\n# Employee metrics\r\nemployees = ai.query(\"Show average salary by department and experience level\")\r\n\r\n# Hiring analysis\r\nhiring = ai.query(\"What's our hiring trend by month for the last 2 years?\")\r\n\r\n# Retention insights\r\nretention = ai.query(\"Calculate employee turnover rate by department\")\r\n```\r\n\r\n### Financial Reporting\r\n```python\r\nai = AIQWAL('mssql+pyodbc://user:pass@server/financial_db')\r\n\r\n# Revenue analysis\r\nrevenue = ai.query(\"Break down revenue by product line and quarter\")\r\n\r\n# Expense tracking\r\nexpenses = ai.query(\"Show top expense categories for this fiscal year\")\r\n\r\n# Profitability\r\nprofit = ai.query(\"Calculate profit margins by business unit\")\r\n```\r\n\r\n## \ud83d\udd27 Configuration\r\n\r\n### Model Configuration\r\n```python\r\n# Use different AI models\r\nai = AIQWAL(\r\n    connection_string='your-db-connection',\r\n    model_path='/path/to/codellama-sql.gguf',  # CodeLlama\r\n    # model_path='/path/to/wizardcoder-sql.gguf',  # WizardCoder\r\n)\r\n```\r\n\r\n### Database-Specific Options\r\n```python\r\n# SQL Server with specific driver\r\nai = AIQWAL(\r\n    'mssql+pyodbc://user:pass@server/db?driver=ODBC+Driver+17+for+SQL+Server',\r\n    auto_connect=True\r\n)\r\n\r\n# PostgreSQL with SSL\r\nai = AIQWAL(\r\n    'postgresql://user:pass@host:5432/db?sslmode=require',\r\n    auto_connect=True  \r\n)\r\n```\r\n\r\n## \ud83d\udee1\ufe0f Security & Safety\r\n\r\nAIQWAL includes built-in safety features:\r\n\r\n- **Query Validation**: Prevents dangerous operations (DROP, DELETE, etc.)\r\n- **SQL Injection Protection**: Uses parameterized queries\r\n- **Schema Validation**: Ensures queries reference valid tables/columns\r\n- **Connection Security**: Supports SSL/TLS for database connections\r\n\r\n```python\r\n# These will be safely rejected:\r\nai.query(\"DROP TABLE users\")  # \u274c Dangerous operation blocked\r\nai.query(\"DELETE FROM orders\")  # \u274c Modification blocked  \r\nai.query(\"Show me customers\")  # \u2705 Safe SELECT query allowed\r\n```\r\n\r\n## \ud83e\uddea Testing\r\n\r\n```bash\r\n# Run all tests\r\npytest\r\n\r\n# Test specific database\r\npytest tests/test_postgresql.py\r\n\r\n# Test with coverage\r\npytest --cov=aiqwal tests/\r\n\r\n# Integration tests\r\npytest tests/test_integration.py\r\n```\r\n\r\n## \ud83d\udcca Performance\r\n\r\nAIQWAL is designed for production use:\r\n\r\n- **Model Loading**: 2-5 seconds (cached after first use)\r\n- **Query Generation**: 1-10 seconds (depending on complexity)  \r\n- **Query Execution**: Database-dependent\r\n- **Memory Usage**: ~500MB-2GB (model-dependent)\r\n\r\n### Benchmarks\r\n\r\n| Database | Connection Time | Query Generation | Simple Query | Complex Query |\r\n|----------|----------------|------------------|--------------|---------------|\r\n| SQLite | <100ms | 2-5s | <100ms | 100-500ms |\r\n| PostgreSQL | 100-300ms | 2-5s | 50-200ms | 200-1s |\r\n| MySQL | 100-300ms | 2-5s | 50-200ms | 200-1s |\r\n| SQL Server | 200-500ms | 2-5s | 100-300ms | 300-2s |\r\n\r\n## \ud83e\udd1d Contributing\r\n\r\nWe welcome contributions! Please see our [Contributing Guide](CONTRIBUTING.md).\r\n\r\n### Development Setup\r\n```bash\r\n# Clone repository\r\ngit clone https://github.com/yourusername/aiqwal.git\r\ncd aiqwal\r\n\r\n# Create virtual environment\r\npython -m venv venv\r\nsource venv/bin/activate  # Linux/Mac\r\n# venv\\Scripts\\activate   # Windows\r\n\r\n# Install development dependencies\r\npip install -e .[dev]\r\n\r\n# Run tests\r\npytest\r\n```\r\n\r\n## \ud83d\udcda Documentation\r\n\r\n- [Full Documentation](https://aiqwal.readthedocs.io/)\r\n- [API Reference](https://aiqwal.readthedocs.io/en/latest/api/)\r\n- [Database Support](https://aiqwal.readthedocs.io/en/latest/databases/)\r\n- [Examples](https://aiqwal.readthedocs.io/en/latest/examples/)\r\n\r\n## \ud83d\udc1b Troubleshooting\r\n\r\n### Common Issues\r\n\r\n**Model Loading Error:**\r\n```python\r\n# Ensure model file exists and is compatible\r\nimport os\r\nprint(os.path.exists('path/to/model.gguf'))\r\n```\r\n\r\n**Database Connection Error:**\r\n```python  \r\n# Test connection string\r\nai = AIQWAL('your-connection-string')\r\nprint(ai.test_connection())\r\n```\r\n\r\n**Query Generation Issues:**\r\n```python\r\n# Check database schema\r\nschema = ai.get_schema()\r\nprint(\"Available tables:\", list(schema.keys()))\r\n```\r\n\r\n### Getting Help\r\n\r\n- \ud83d\udcda [Documentation](https://aiqwal.readthedocs.io/)\r\n- \ud83d\udc1b [Issue Tracker](https://github.com/yourusername/aiqwal/issues)\r\n- \ud83d\udcac [Discussions](https://github.com/yourusername/aiqwal/discussions)\r\n- \ud83d\udce7 [Email Support](mailto:support@aiqwal.com)\r\n\r\n## \ud83d\udcc4 License\r\n\r\nAIQWAL is licensed under the MIT License. See [LICENSE](LICENSE) for details.\r\n\r\n## \ud83d\ude4f Acknowledgments\r\n\r\n- [SQLCoder](https://github.com/defog-ai/sqlcoder) for the excellent SQL generation model\r\n- [llama.cpp](https://github.com/ggerganov/llama.cpp) for efficient model inference\r\n- [SQLAlchemy](https://www.sqlalchemy.org/) for universal database connectivity\r\n- The open-source community for continuous inspiration\r\n\r\n## \u2b50 Star History\r\n\r\nIf you find AIQWAL useful, please consider starring the repository!\r\n\r\n[![Star History Chart](https://api.star-history.com/svg?repos=yourusername/aiqwal&type=Date)](https://star-history.com/#yourusername/aiqwal&Date)\r\n\r\n---\r\n\r\n**Made with \u2764\ufe0f by the AIQWAL team**\r\n\r\n*Transform natural language into SQL queries for ANY database in the world!*\r\n",
    "bugtrack_url": null,
    "license": null,
    "summary": "AI Query Writer for Any Language - Universal SQL generator that works with ANY database",
    "version": "1.0.0",
    "project_urls": {
        "Homepage": "https://github.com/shivnathtathe/aiqwal"
    },
    "split_keywords": [
        "ai",
        "sql",
        "database",
        "natural-language",
        "llm",
        "sqlalchemy",
        "query-generator"
    ],
    "urls": [
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "9304334c346b172a8a67a7bc153bbc9975a2537cbc418559516d672afb0c3110",
                "md5": "04672bc1e8e6b5edc682635950d02e2e",
                "sha256": "e2c66df00596be087f2598871dc1d977b75e6f01ad23b96783eebddd1e4e559c"
            },
            "downloads": -1,
            "filename": "aiqwal-1.0.0-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "04672bc1e8e6b5edc682635950d02e2e",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.8",
            "size": 42356,
            "upload_time": "2025-08-20T09:20:21",
            "upload_time_iso_8601": "2025-08-20T09:20:21.242285Z",
            "url": "https://files.pythonhosted.org/packages/93/04/334c346b172a8a67a7bc153bbc9975a2537cbc418559516d672afb0c3110/aiqwal-1.0.0-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "20091487cf9c2a7d0b8805c8009585018f4dedd737c490310be5ec497ec2e366",
                "md5": "53cd4807308be0f1234de5d17e876fd2",
                "sha256": "629730a341f97f38268d7532c6084583648bc6ac28e6a840f9ac34489ede82be"
            },
            "downloads": -1,
            "filename": "aiqwal-1.0.0.tar.gz",
            "has_sig": false,
            "md5_digest": "53cd4807308be0f1234de5d17e876fd2",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.8",
            "size": 40518,
            "upload_time": "2025-08-20T09:20:23",
            "upload_time_iso_8601": "2025-08-20T09:20:23.229978Z",
            "url": "https://files.pythonhosted.org/packages/20/09/1487cf9c2a7d0b8805c8009585018f4dedd737c490310be5ec497ec2e366/aiqwal-1.0.0.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2025-08-20 09:20:23",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "shivnathtathe",
    "github_project": "aiqwal",
    "github_not_found": true,
    "lcname": "aiqwal"
}
        
Elapsed time: 3.17696s