A Real-Time PostgreSQL Monitoring, Analysis, and Visualization Developer Tool
MIT License
Database Visualization: Get a holistic view of your entire database schema, allowing for a better understanding of relations, data distribution, and table structures.
Query Performance Analysis: With ScanQL's testing mechanism, analyze the planning and execution times of generic SELECT and UPDATE queries, pinpointing potential bottlenecks and inefficiencies.
ER Diagram: Visualize intricacies of your database structure with our enhanced ER Diagram. Experience an interactive representation of your database's relationships and dependencies, making comprehension and optimization more intuitive than ever.
Holistic View: Go beyond traditional data views and understand your database from a macro and micro perspective.
Empowered Decision Making: Make informed decisions about schema changes, indexing, and more based on the insights ScanQL offers.
Automated Tests: Without writing a single line of SQL, get performance metrics on commonly used SELECT and UPDATE queries as soon as you connect your database
**Note**
PostgreSQL Database Provider Access: Ensure you have the appropriate permissions with your PostgreSQL database provider. Some metrics might be restricted depending on the access level you have.
pg_stats: If you are leveraging pg_stats
for metrics, you may need additional privileges or access rights. Check with your PostgreSQL database provider or your system
administrator for assistance.
If you encounter any issues or need more information, consult your PostgreSQL documentation or feel free to reach out to us!
At ScanQL, your privacy and security are paramount:
No Storage of URI Strings: We understand the significance of database URIs. ScanQL is designed to never store or cache your database URI strings, ensuring they remain confidential.
Data Privacy: Personal data and database contents remain entirely within your domain. ScanQL does not store, share, or transmit your data.
Secure Analysis: The metrics and insights provided by ScanQL are processed securely without any external sharing or storage. Our commitment is to offer optimization insights without compromising on security.
We welcome contributions! If you find a bug or want to propose a feature, feel free to open an issue or create a pull request.
ScanQL is licensed under the MIT License. See LICENSE.md for more details.
Developed By | Github |
---|---|
Daniel Kim | |
Sam Heck | |
Yahya Talab | |
Danny Murcia | |
Kurt Bulau |