HeartingU / Dogicat_DMS

DogiCat DMS 
 Don't just browse your database. Follow the evidence. 
 A Python desktop workbench for exploring databases, tracing records, comparing changes, and investigating with your own AI model. 
 简体中文 ·
 Quick start ·
 Try the demo ·
 AI setup 
---
**The payment succeeded. Why is the order still pending?**
Start with one record. Follow its relationships, compare what changed, and share the evidence—not access to your entire database.
DogiCat brings everyday database management and a read-only investigation workspace into the same app. SQLite and the built-in demo work without extra Python packages. AI is optional.
## Five ways to go beyond a query result
| You need to… | DogiCat helps you… |
| --- | --- |
| Understand one suspicious record | Trace records across captured tables using declared foreign keys or relationships you explicitly confirm. |
| See exactly what changed | Compare before/after snapshots, including old and new field values, added/deleted records, and schema changes. |
| Reproduce a problem with someone else | Review field masking, export a `.dogicatcase`, and reopen it offline without source-database credentials. |
| Inspect a dump without its server | Preview supported SQLite and simple MySQL SQL dumps in an isolated in-memory database, with a compatibility report. |
| Get a second pair of eyes | Bring an API or local model, inspect the context, and ask for explanations or SQL drafts. **AI never executes SQL.** |
## A record is the starting point
The included fictional dataset has an order with a successful payment but a stale status:
~~~mermaid
flowchart LR
 O["orders · 1001 status = pending"]
 C["customers · 1"]
 I["order_items Keyboard × 1"]
 P["payments status = success"]
 O --- C
 O --- I
 O --- P
~~~
*Illustrative relationships from the demo dataset—not an application screenshot or proof of why the inconsistency occurred.*
Follow the records → capture a baseline → make a controlled change → compare → review and share.
## Start in one command
Download or clone this repository, then run:
~~~sh
git clone https://github.com/HeartingU/Dogicat_DMS.git
cd Dogicat_DMS
python main.py
~~~
You need **Python 3.9+ with Tk**. On Windows, use a Python installation that includes Tcl/Tk. No database server, model, or API key is needed for the demo.
| Database | Setup |
| --- | --- |
| SQLite | Included with Python; no extra driver needed. |
| MySQL | Install `mysql-connector-python`. |
| PostgreSQL | Install `psycopg2-binary`. |
Install only the optional drivers you need:
~~~sh
python -m pip install mysql-connector-python psycopg2-binary
~~~
The app starts in Chinese by default. Choose **菜单 → 语言 → English** to switch. Language changes are remembered and preserve open tabs, SQL and input; some older administration messages are still Chinese.
## Try the investigation in two minutes
1. Open **Menu → Tools → Try demo**. DogiCat creates a fresh, fictional SQLite database.
2. Select `orders`, choose `id`, enter `1001`, and click **Trace