A multi-database tool plugin for OpenCode that provides direct SQL access.
Supported Databases: MySQL, MariaDB, PostgreSQL, SQL Server, SQLite
Before executing write operations, you must grant consent. This is a safety feature designed to protect your data by ensuring you consciously acknowledge each operation.
When you attempt a write operation (INSERT, UPDATE, DELETE, DROP, etc.) for the first time, you will be prompted to grant consent. This gives you a moment to verify the operation before it executes.
Your identity (name, email, hostname) is recorded with each consent grant for audit purposes.
db { "action": "consent", "grant": true }Choose the level that matches your workflow:
- Global: Permanent across all projects
- Project: Permanent for a specific project
- Session: Valid for 24 hours
- Operation: Required for each write (most cautious)
-- Set consent level
db { "action": "consent", "grant": true, "scope": "session" }db { "action": "consent" }db { "action": "consent", "grant": false }{
"plugins": ["database-admin"]
}Create ~/.config/opencode/db-connections.json:
{
"default": {
"Server": "localhost",
"Database": "mydb",
"User Id": "root",
"Password": "secret"
}
}The plugin automatically discovers connections from:
- .NET: appsettings.json, appsettings.Development.json
- Node.js: .env, .env.local
- Python: .env, settings.py
- Java: application.properties
-- Auto-discover connection
db { "query": "SELECT * FROM users LIMIT 5" }
-- Specific connection
db { "query": "SELECT * FROM orders", "connection": "production" }
-- Direct URL
db { "query": "SELECT 1", "connection": "mysql://root:pass@localhost:3306/mydb" }db { "connection": "discover" }This software is provided "AS IS" without warranty.
By granting consent for write operations, you acknowledge responsibility for verifying your queries before execution.
Contact: nyingimaina@gmail.com
License: MIT (see LICENSE) | Commercial License