Results for “database-upsert”

Scrapes YouTube channel or video metadata via the YouTube Data API, downloads transcripts with yt-dlp, chunks them for search, and upserts results into a database.

Sets up a Supabase MCP server for managing Postgres databases through a RESTful API, including fetching tables, adding roles, and running queries.

Optimizes database queries and improves performance across PostgreSQL and MySQL systems by analyzing execution plans, designing index strategies, and tuning configurations.

Create, schedule, and verify database backups with support for full, incremental, and point-in-time recovery strategies. Use when the user requests database backup or provides relevant inputs for this workflow.

Manage Azure PostgreSQL Flexible Server deployments using the .NET SDK. Create servers, databases, firewall rules, configurations, backups, and high availability.

Manage Azure MySQL Flexible Server deployments using the .NET SDK. Create servers, databases, firewall rules, configurations, backups, and configure high availability.

Integrate Azure OpenAI and OpenAI services in .NET applications for chat completions, embeddings, image generation, audio transcription, and assistants.

Provides structured prompts for analyzing, planning, and executing .NET framework upgrades, covering project assessment, dependency management, code modernization, CI/CD updates, testing, and documentation.

Optimize PostgreSQL databases with advanced features, performance tuning, and best practices for JSONB, full-text search, window functions, and indexing.

Manage datasets, tables, and jobs in BigQuery. Run SQL queries, manage BigQuery resources, and perform basic data ingestion and analysis.

Nested Sets

Deploy privileged access management for database systems including Oracle, SQL Server, PostgreSQL, and MySQL, covering session proxy configuration, credential vaulting, query auditing, dynamic credential generation, and least-privilege database roles.

Expert-level PostgreSQL database administration, advanced queries, performance tuning, and production operations

Implements database replication, failover, backups, connection pooling, and monitoring for production PostgreSQL, MySQL, and MongoDB systems.

Ecto database toolkit reference for Elixir. Covers schemas, changesets with validation, composable query DSL, joins, preloading, aggregates, migrations, transactions with Ecto.Multi, and embedded schemas.

Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures. Masters advanced indexing, N+1 resolution, multi-tier caching, partitioning strategies, and cloud database optimization. Handles complex query analysis, migration strategies, and performance monitoring. Use PROACTIVELY for database optimization, performance issues, or scalability challenges.

Upserts a validated MDX book corpus into Supabase via Drizzle, hydrating books, chapters, sections, and chunks tables while preserving stable bookmark anchors and only re-embedding changed content.

Provides safe, reversible database schema change patterns for PostgreSQL, MySQL, and common ORMs, with guidance on zero-downtime deployments, rollbacks, and migration tooling.

Database Naming Standards

Database Review — Forge Skill

Manage Cloudflare D1 SQLite databases and KV key-value stores with setup commands, TypeScript usage patterns, and a decision matrix for choosing between them.

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Manages vector embeddings with Pinecone for semantic search, recommendation, and RAG pipelines.

Guides backup, restore, snapshot, PITR, retention, and disaster recovery planning for PostgreSQL and AWS, emphasizing tested restores and RTO/RPO alignment.

Expert knowledge for Azure Cosmos DB development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when using Cosmos DB NoSQL/Mongo/Cassandra/PostgreSQL APIs, change feed, vector search, multi-region, or AI/RAG workloads, and other Azure Cosmos DB related development tasks. Not for Azure Table Storage (use azure-table-storage), Azure SQL Database (use azure-sql-database), Azure Database for MySQL (use azure-database-mysql), Azure Database for PostgreSQL (use azure-database-postgresql).

Databases Design Expert Skill

Up API skill. Use when working with Up for accounts, attachments, categories. Covers 20 endpoints.

Ingests case studies, past proposals, and boilerplate from library/inbox into structured indexes. Use when the user requests to 'index proposal library', 're-index case studies', 'ingest inbox docs', or 'validate library'.

Administra bases de datos PostgreSQL, MySQL, Redis y SQLite: diseña esquemas, optimiza queries, configura migraciones, replicación y backups.

MySQL relational database. Covers queries, indexes, and optimization. Use when working with MySQL databases. USE WHEN: user mentions "mysql", "mariadb", asks about "AUTO_INCREMENT", "ON DUPLICATE KEY UPDATE", "GROUP_CONCAT", "mysql specific syntax" DO NOT USE FOR: PostgreSQL - use `postgresql` instead, MongoDB - use `mongodb` instead, Oracle - use `oracle` instead, SQL Server - use `sqlserver` instead

Explains MariaDB's REPLACE statement: its delete-then-insert behavior, when it triggers, data-loss risks, and the upsert alternative. Use when writing or reviewing REPLACE statements.

Adds a new database table and generates all six layers of the platform codebase, from schema to UI, with validation at each step.

dbt (data build tool) transforms data in your warehouse using SQL SELECT statements. Learn project setup, models, tests, documentation, incremental materializations, and integration with data warehouses like PostgreSQL, BigQuery, and Snowflake.

Use when searching NCBI Entrez databases (pubmed, gene, protein, nuccore, snp, geoprofiles) with query strings and field qualifiers to retrieve record UIDs for downstream processing.