Shows how to encrypt and decrypt bytes with AES in pycryptodome through Crypto.Cipher.AES: generate a 16, 24, or 32 byte key with get_random_bytes, encrypt with AES-GCM using encrypt_and_digest, store nonce, ciphertext, and tag together, and decrypt with decrypt_and_verify, plus the CBC pad and unpad variant. Use when…
Diagnoses a Percona Server for MySQL 8.0 startup where the config_file variable does not point at the configuration file an admin moved to /etc/percona, by printing the build-specific option-file search order, separating the main defaults file from !includedir merges, and running a sentinel-value test. Use when config…
Shows how to build a public audit history projection for document approvals that cannot leak private review notes: filter at projection time on both document status and event visibility, store the public read model in a separate table with no private columns, and handle unpublish, rebuilds and counts. Use when exposin…
Shows how to design a read-only service API with modular least-privilege scopes: one scoped service token per module, read-only enforcement at route, scope and data layers, published-only filtering inside the base query, allowlist response projection for user privacy, and coarse opt-in handling for presence data. Use …
Vectle found the following relevant skills: - agent's scheduled run failed: different python than the notebook kernel, import error - atlassian-python-api 3.41.5 fails on import with ModuleNotFoundError: No module named 'bs4'
Vectle found the following relevant skills: - agent's scheduled run failed: different python than the notebook kernel, import error - atlassian-python-api 3.41.5 fails on import with ModuleNotFoundError: No module named 'bs4'
Before applying any schema-drift fix, build the downstream impact list first: find every model, dashboard, and check that reads the changed column, then fix drift by adding compatibility, such as a renamed column kept alongside the old one, instead of renaming in place. Use when an agent repairing schema drift in a pi…
Fixes a Looker dashboard broken by a removed field, found through content validation, by restoring the field or updating the dashboard elements. Use when the Content Validator lists a dashboard with a field removed error. Not for a dashboard broken by a filter or scheduling problem.
Fixes a Looker error saying a field was not found in a view for usage_events churn_risk_score so the CS dashboard renders again, by repairing the LookML reference. Use when one dashboard or tile errors on the field. Not for a field that never existed in the data.
Fixes a Metabase card that fails because a column no longer exists by syncing the schema and updating the question to the current field name. Use when a saved question breaks after a table change. Not for a whole database connection failure affecting every card.
Fixes a Grafana panel that reports its data source was not found after a migration by restoring the data source UID or repointing the dashboard panels. Use when dashboards break after an instance move or provisioning change. Not for a data source that exists but returns query errors.
Fixes a Looker PDT build that fails because the table already exists, leaving a dashboard empty, by clearing the stale derived table and rebuilding. Use when the PDT regenerator errors and dependent tiles show no data. Not for a PDT that builds but returns wrong rows.
Builds an authenticated EF Core employee directory that returns only a minimal public DTO: exclusion of blocked and system accounts before search and counting, server-side Select projection with no admin fields, an allowlisted sort with an id tie-breaker, and clamped pagination. Use when a directory endpoint returns u…
Fixes a missed downstream ref after an agent renamed a model file, leaving a stale ref that fails compilation. Use when a rename was done by file operation without updating callers. Not for intentional model removals with planned downstream changes.
Fixes an agent failing to download dbt Cloud run artefacts by using a guessed or stale URL, covering the runs API, artefact paths per run, and account and job identifiers. Use when an artefact download 404s or returns an error page. Not for a run that produced no artefacts because it failed at compile time.
Fixes a dbt ref that stops resolving after a model rename, covering the model name versus the file name, stale partial parsing state, and downstream refs that still use the old name. Use when compilation says a ref cannot be found. Not for a ref to a model in another project or package.
Vectle found the following relevant skills: - agent ai gateway fallback pointed at a deleted gateway - agent deleted old migration files thinking they were stale - now new environments cant bootstrap
Vectle found the following relevant skills: - agent diffed against the wrong baseline - it compared the redline to v2 instead of v3 and every real change showed... - [agent verified the webhook signature against the wrong secret - it used the AP…
Vectle found the following relevant skills: - agent deployed the notebook to airflow without pinning dependencies, build failed - candidate ranking agent changed its scores between runs - temperature wasn't set to 0 and the rubric drifted