sql_conn
sql_conn is a production-ready Flutter plugin that allows Android applications to connect directly to SQL SERVER databases using JDBC.
It provides a clean, type-safe, null-safe Dart API powered by Pigeon, and a high-performance Android backend.
This plugin is designed for LAN / internal network / enterprise / industrial use-cases where direct database connectivity from a mobile device is required.
✨ Features
- Android-only direct SQL connectivity
- Database support:
- Prepared statements (parameterized queries)
- Stored procedure execution
- SQL script / batch execution
- Fully null-safe Dart API
- Type-safe Flutter ↔ Android bridge using Pigeon
📱 Platform Support
| Platform |
Support |
| Android |
✅ Yes |
| iOS |
🚧 Under construction |
| Web |
💭 Planning |
| Windows |
🚫 No |
| MacOs |
🚫 No |
Direct database connections from mobile apps should only be used in trusted or internal networks.
🚀 Installation
Add to pubspec.yaml:
dependencies:
sql_conn: ^2.0.0
⚙️ Basic Usage
Connect to a database
await SqlConn.connect(
connectionId: "mainDB",
host: "192.168.1.10",
port: 1433,
database: "MyDatabase",
username: "admin",
password: "Password@123",
);
Read data
final rows = await SqlConn.read(
"mainDB",
"SELECT * FROM users WHERE role = ?",
params: ["admin"],
);
print(rows);
Write / Update / Delete
final count = await SqlConn.write(
"mainDB",
"UPDATE users SET active = ? WHERE id = ?",
params: [true, 101],
);
print("Rows affected: $count");
Call Stored Procedure
final result = await SqlConn.callProcedure(
"mainDB",
"sp_generate_report",
params: [2026, "JAN"],
);
Execute SQL Script
await SqlConn.executeScript(
"mainDB",
"""
CREATE TABLE logs(id INT, message VARCHAR(255));
CREATE INDEX idx_logs ON logs(id);
""",
);
Disconnect
await SqlConn.disconnect("mainDB");
🧩 Multiple Connections
await SqlConn.connect(connectionId: "db1", dbType: DatabaseType.sqlServer, ...);
await SqlConn.connect(connectionId: "db2", dbType: DatabaseType.postgres, ...);
final a = await SqlConn.read("db1", "SELECT * FROM table1");
final b = await SqlConn.read("db2", "SELECT * FROM table2");
🔧 Custom JDBC URL
await SqlConn.connect(
connectionId: "legacy",
host: "",
port: 0,
database: "",
username: "sysdba",
password: "masterkey",
customJdbcUrl: "jdbc:firebirdsql://192.168.1.9/employee",
);
🧠 State Management
sql_conn is a stateless service API.
You can integrate it with any state manager:
- Provider
- Riverpod
- Bloc
- GetX
- Service Locators
- Connection lifecycle is fully controlled by your app.
⚡ Performance
- Prepared statement reuse
- Non-blocking platform channel
- Minimal memory overhead
🔐 Security
- Prepared statements prevent SQL injection
- No credential logging
