Skip to content

IcyDrae/Dbx

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Dbx

Overview

Dbx is a cross-platform command-line database browser written in C#. It allows users to explore, inspect, and query databases directly from the terminal without needing a graphical interface.

The tool focuses on fast navigation, clean output, and developer productivity.

Features

  • Connect to SQLite, PostgreSQL, MySQL
  • Browse tables and schemas
  • View and paginate rows
  • Run custom SQL queries
  • Export data to CSV / JSON
  • Visualize table relationships
  • Query history and run query from history

Motivation

This project exists to provide a lightweight and scriptable alternative to GUI database tools while improving backend and systems programming skills.

Usage

Examples:

dbx config
dbx config add <name> <type> <host> <port> <db> <user> <password>
dbx connect sqlite mydb.db
dbx use local-mysql
dbx tables
dbx describe users
dbx list users
dbx list users --where="first_name=Joe"
dbx query "SELECT * FROM users"
dbx query "SELECT * FROM users" --csv # Export to csv
dbx query "SELECT * FROM users" --json # Export to json
dbx history
dbx history 2 # Run the second command from the history
dbx visualize
dbx export users --csv

Architecture

The project follows a layered architecture:

  • CLI Layer
  • Core Logic
  • Database Providers
  • Schema Introspection
  • Output Rendering
  • Security & Encryption

Disclaimer

Only use this tool on databases you own or have permission to access.

License

MIT

About

Dbx is a cross-platform terminal-based database browser in C# for exploring, querying, and exporting SQLite, MySQL, and PostgreSQL databases.

Resources

Stars

Watchers

Forks

Packages

 
 
 

Contributors