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.

cookieYYearning

Features

Star history