coders-dba 0.7.7

coders-dba

coders-dba is an AI-powered CLI for managing databases with natural language. It helps you explore schemas, run diagnostics, and execute safe queries by talking to your database through an LLM-backed assistant.

Highlights

• Conversational database management from the terminal
• Works with an LLM provider (tested with Ollama)
• Simple init-based configuration

Installation

Prerequisites

• .NET SDK 8.0+
• Access to NuGet.org (or your private feed)

Install as a global tool

dotnet tool install -g coders-dba

Update

dotnet tool update -g coders-dba

Uninstall

dotnet tool uninstall -g coders-dba

Getting Started

1) Enter the coders-dba console

coders-dba

2) Generate the config file

coders-dba init

Configuration (Example)

The following is an example of the config created by coders-dba init:

llmOptions:
  # The LLM provider to use. Examples:
  # 'ollama(gpt-oss:20b)' 'gemini(gemini-2.5-pro)' 'chatgpt(gpt-4o-mini)'
  provider: "ollama"
  # The model to use for LLM requests.
  model: "gpt-oss-safeguard:20b"
  # The host URL for the LLM service.
  url: "http://localhost:11434"
  # The API key for authenticating with the LLM service.
  apiKey: "OLLAMA_API_KEY"
  # Number of conversational turns to keep.
  maxHistoryTurns: 12
  # Timeout in seconds for LLM requests.
  timeoutSeconds: 300
  # Stream responses if supported by provider.
  stream: false

# The database management system used, e.g., 'sqlite', 'mysql', 'oracle', 'postgresql', 'mssql'
dbms: "mysql"
host: "localhost"
port: 3308
user: "root"
password: "StrongRootPassword!"
database: "mydatabase"

Tested Environment

• Tested with model: gpt-oss-safeguard:20b
• Tested with provider: ollama

Current Support

• Supported DBMS: mysql only
• Planned: oracle, postgresql

Tips

• Ensure your LLM service is reachable from the machine running coders-dba.
• Keep credentials secure and avoid committing config files that contain secrets.
• To bump the packaged version, edit the coders-dba/VERSION file or run publish-nuget.bat <version>. The batch script now picks the value from that file automatically before packing.

License

See LICENSE.