cookieY/Yearning
Yearning
Yearning is a MySQL SQL audit platform and database change management system. It provides a governance framework for reviewing, approving, and auditing SQL statements executed against MySQL databases.
The platform features an AI-powered SQL optimizer that suggests performance improvements and converts natural language requests into executable SQL code. It manages database changes through an approval-based workflow engine that includes automated rollback generation and rule-based syntax validation.
The system covers role-based access control, security compliance with multi-factor authentication and data encryption, and query monitoring with field-level data anonymization. Additional capabilities include transactional execution for data manipulation, schema inspection, and the merging of table alteration commands.
Features
- SQL Execution Audits - Provides a governance platform for reviewing and approving SQL statements executed against MySQL databases to prevent data loss.
- Approval Workflow Management - Requires designated reviewers to approve SQL scripts through a workflow before production execution.
- Database Change Management Systems - Provides a workflow tool for managing DDL and DML changes through approval tickets and automated rollback generation.
- Security and Performance Constraints - Evaluates submitted SQL against predefined security and performance constraints using automated checkers.
- SQL Syntax Checking - Provides automated checking of SQL statements against security rules and coding standards before execution.
- Compliance & Audit Tools - Enforces multi-factor authentication and data encryption while maintaining historical query logs for audit purposes.
- Database Access Controls - Manages user permissions and role-based access to restrict sensitive database operations.
- Role-Based Access Control - Implements a permission management framework that restricts database operation access based on user roles and data source rules.
- Workflow Approval Gates - Implements an approval-based workflow engine requiring reviewer sign-off before executing scripts on production.
- Database Change Tickets - Creates structured tickets for database changes with automated syntax validation and generated rollback statements.
- Custom Validation Rules - Allows the definition of configurable validation rules for database operations on a per-source basis.
- SQL Query Validators - Automatically evaluates SQL statements against predefined rules to ensure adherence to security and coding standards.
- Natural Language Querying - Converts human-readable text descriptions into executable database statements using artificial intelligence.
- Performance Recommendations - Provides AI-powered SQL optimization that suggests performance improvements for database statements.
- AI-Powered SQL Optimizers - Provides an intelligence layer that converts natural language to SQL and suggests performance improvements.
- SQL Query Optimizations - Uses artificial intelligence to improve database performance and convert natural language requests into executable SQL code.
- SQL Rollback Generation - Automatically creates inverse SQL statements during the audit process to allow for quick recovery from failed changes.
- Data Encryption - Includes mechanisms to encrypt sensitive information to prevent unauthorized access to stored data.
- Multi-Factor Authentication - Enforces a second form of identity verification during the login process to increase account security.
- Database Query Monitors - Implements a tracking system for database queries with historical logging and field-level anonymization.
