[JS] CSQP - Custom System Query Panel

[silkroadbrowser]

Hi all,

I'm working on CSQP, a lightweight database management and team collaboration tool built in Python, running on Termux (yes, on my phone!). It’s in the MVP stage, and I’d love to hear your feedback to shape it further.

This software aims to be useful for developers, designers, and SQL programmers in assisting server owners.

What is CSQP?

CSQP is an intermediate solution for server admins to create tailored SQL panels. It supports MSSQL (Silkroad, Knight Online) and MySQL/MariaDB (Metin2) with a Flask-based web interface. Inspired by Silkroad’s job systems and server management needs, it’s built to simplify database management and team collaboration.

Current Features (MVP)

• User Settings: Users can configure personal details (username, contact info) via a clean interface.
• Database Connections: Admins set up MSSQL/MySQL connections using `pyodbc` and `pymysql`. Connections are encrypted with `cryptography` (Fernet) for security.
• Security:
  • Database credentials are stored encrypted.
  • 2FA for critical actions (e.g., modifying DB settings).
  • Zero trust principles for maximum protection.
• Demo Panel Editor: A basic editor to design and test SQL panels (check the screenshot below).
• Termux-Powered: Runs on Termux with Flask, SQLAlchemy, and a lightweight setup—no heavy servers needed.

DarkMode:
LightMode:

Future Plans

• Procedure/Panel Market: A marketplace for sharing custom SQL procedures and panels.
• More DB Support: Planning to add PostgreSQL, MongoDB, or others based on demand.
• Enhanced UI: Improving the Flask dashboard with Vue.js or similar for a smoother experience.
• Team Features: Roles, permissions, and advanced collaboration tools.

What I Need from You

• Is This Useful?: Would you use a free tool like CSQP for your private server? What features would make it a must-have?
• Feature Requests: More database types? Specific panel templates? Game-inspired mechanics (e.g., Silkroad job ranks)?
• Technical Tips: Ideas for optimizing Termux, Python, or `cryptography` setup? Alternative security libraries?
• UI/UX: How can I make the panel editor more intuitive?

Links

• Landing Page:
• Demo Panel: (online for ~1 week for testing)
• GitHub: (feel free to open issues or suggest features!)
• Reddit Post for Termux:

I’m developing this solo on Termux, so any feedback, criticism, or crazy ideas are welcome. If you’re a coder, server admin, or private server fan, what would you add to CSQP? Let’s make this epic! ��

Cheers,