Results for “database-views”

Explains MariaDB-specific view syntax and behavior, including CREATE OR REPLACE VIEW, ALGORITHM options, SQL SECURITY, updatability rules, and WITH CHECK OPTION, for writing or reviewing MariaDB view statements.

Database management and queries. Connect to SQL and NoSQL databases, run queries, and manage schemas.

Fetch dataset metadata, paginate rows, search text, apply filters, and download parquet URLs from the Hugging Face Dataset Viewer API.

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.

Database Naming Standards

Database Review — Forge Skill

Query documented public database APIs with explicit endpoints, filters, pagination, and provenance for reproducible retrieval of scientific, regulatory, or financial facts.

Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering.

Guides database design, implementation, optimization, migrations, data pipelines, and operations across SQL and NoSQL platforms.

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.

Design and operate databases avoiding common scaling, reliability, and data integrity traps.

Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering.

Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering.

Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering.

Designs normalized database schemas, creates indexes, writes efficient queries, and manages transactions and data integrity.

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

Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Connect to PostgreSQL, MySQL, SQLite, and SQL Server databases using SQLAlchemy, Pandas, and DuckDB. Read and write tables, manage sessions, and handle connection strings securely.

Use when running analytical SQL over Parquet/CSV/JSON without a warehouse, replacing pandas for data wrangling, joining S3 data in-place, building local data marts, or embedding OLAP into an app. Triggers: read_parquet/read_csv setup, partitioned dataset queries, hive partitioning, glob patterns for S3, COPY TO export, attach Postgres/MySQL, UDFs in Python/R, MotherDuck cloud sync, columnar performance vs row stores. NOT for OLTP workloads (concurrent writes), distributed analytics at petabyte scale (use Spark/Trino), or vector search (use pgvector/Lance).

Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering.

Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering.

Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows. Use when the user asks to write, edit, rewrite, review, format, debug, tune, or explain SQL; create or refactor PL/SQL; use SQLcl, Liquibase, ORDS, JDBC, node-oracledb, Python, Java, .NET, or database frameworks; troubleshoot queries, sessions, locks, waits, indexes, optimizer plans, AWR, ASH, migrations, schemas, users, roles, privileges, backup, recovery, Data Guard, RAC, multitenant, containers, monitoring, auditing, encryption, VPD, or safe agent database operations.

Ingest, index, search, and edit video and live streams with timestamps, subtitles, overlays, and real-time alerts.

Read Phenomena

Remove MariaDB REST service objects with DROP REST statements, including services, schemas, data mapping views, procedures, functions, content sets/files, auth apps, users, and roles, using IF EXISTS to avoid errors.

Explains syntax differences for common SQL operations across PostgreSQL, MySQL, SQL Server, and Oracle, including auto-increment keys, string concatenation, date functions, pagination, booleans, JSON, case sensitivity, and recursive CTEs.

Audit database schema for consistency, validation, and industry standards. Use when reviewing schema design, naming conventions, constraints, indexes, or migrations. Destructive-op gates → plan-data-integrity. Who-can-read-what RLS → plan-rls-audit. Restore/RPO → plan-backup-dr.

Guides database design, implementation, query optimization, migrations, data pipeline development, and operations across SQL and NoSQL platforms.

Guides database design and operations to avoid common scaling, reliability, and data integrity pitfalls.