Benefits of Using Metis
Stay ahead of the game: Catch DB issues before they catch you.
You can implement Metis in a few different ways to ensure it fits with the rest of your tech stack seamlessly, and that it respects the privacy of your organization's data. Our engineers worked hard to simplify the instrumentation process and minimize the impact on performance.
An Illustration of how Metis is integrated at different stages of development
A database is a complicated system, many things can go wrong when deploying a new version
- Data Loss
- Application Errors
- Poor Data Quality
- Slow Performance
- Security Breach
- Violation of Regulations
Metis works with you across the software development lifecycle. We provide a wide range of solutions for every aspect of database-related development.
- Analyze a single SQL Command
- Predict the impact of new changes in the app on the production DB by analyzing the SQL commands generated during QA tests
- Analyze the planned changes in the database schema (also known as schema migration)
- Analyze the schema of the database
AFTER the deployment of the new version
Monitor the Production environment, focusing on the queries recently added
General monitoring of the Production environment.
Quickly analyze an SQL command using the web app Query Analyzer. Just provide the SQL command and its execution plan. No need to install anything as the analysis is done from the web. No need to connect to the database, as all the analysis is done using the execution plan.
Another method for analyzing an SQL command is using Metis CLI. The main advantages of using a CLI are:
- No need to provide an execution plan:since the CLI is connected to the database, it can retrieve the execution plan
- Deeper analysis:
If you have unit or integration tests running as part of your CI/CD which interact with a database, you can get a report summarizing your database interactions efficiency, issues and the steps required to fix them.
For your convenience we offer an SDK and GitHub Workflows, to ease integration and present reports inside your pull request page.
Metis offers two ways to observe your production database in order to analyze performance.
Production Metadata Collector (PMC)
For those who don't want to install extra SDKs in their production server, we offer another solution.
By setting up the PMC, you enable Metis to collect metadata such as the general structure, usage and statistics of the production database. Metis can then be configured to simulate how different SQL Commands would run in production without affecting production performance or running the risk of exposing production data.
As developers, we know how intimidating it can be to change the shcema of the live production database.
Having a PMC configured enables Metis to detect upcoming changes in database schemas that can potentially break production. Metis then alerts you, and gives you the solution to remediate the issue.