sql-databases
304
postgresgpt-sql-generator
Acts as PostgresGPT to generate PostgreSQL queries from natural language descriptions, adhering to specific syntax preferences for date functions.
ECNU-ICALK
databases
sorting
stars
current ordering strategy
query
all entries
refine the visible subset
sql-databases
304
sql-query-generation-with-explicit-joins
Generates SQL queries adhering to the constraint of avoiding NATURAL JOIN syntax, using explicit JOIN conditions instead.
ECNU-ICALK
databases
sql-databases
304
beginner-friendly-sql-explanation
Explains or rewrites SQL concepts for beginners using concise language. Ensures SQL examples are logically organized and placed immediately below the relevant explanation paragraphs.
ECNU-ICALK
databases
sql-databases
304
generate-sql-update-book-descriptions
Generates SQL UPDATE statements to populate book descriptions in a database, strictly adhering to word count, content exclusion, and formatting constraints.
ECNU-ICALK
databases
sql-databases
304
mssql-audit-trigger-generator
Создает T-SQL триггер для аудита изменений (INSERT, UPDATE, DELETE) в таблицу истории, поддерживая JOIN-ы для поиска ответственных лиц и агрегацию строк.
ECNU-ICALK
databases
sql-databases
304
gnration-sql-ddl-depuis-description-de-schma-textuel
Convertit une description textuelle structurée d'un modèle de données (entités, associations, clés étrangères, règles de fusion) en code SQL CREATE TABLE. Applique les fusions de tables spécifiées et respecte les contraintes d'intégrité référentielle.
ECNU-ICALK
databases
sql-databases
304
oracle-sql
根据用户需求生成Oracle SQL查询语句，并严格按照纯文本格式输出，不使用Markdown代码块或解释，以防止终端显示乱码。
ECNU-ICALK
databases
sql-databases
304
postgresql-inventory-and-price-tracking-schema
Designs PostgreSQL schemas and queries for tracking item prices and stock counts over time, ensuring immutable creation records and hourly history logging.
ECNU-ICALK
databases
sql-databases
304
sqlite-fts5-full-text-search-implementation
Implement full-text search using SQLite's FTS5 extension with SQLAlchemy. This includes creating a virtual FTS table, synchronizing data between standard tables and the FTS index, and executing raw SQL queries for search operations.
ECNU-ICALK
databases
sql-databases
304
sql-to-csv-data-comparison-with-cleaning
Generate a Python script to compare MySQL database data with a CSV file, applying specific data cleaning (trimming whitespace, standardizing nulls) to ensure accurate matching.
ECNU-ICALK
databases
sql-databases
304
mysql-vs-csv-data-comparison-with-cleaning
Create a Python script to compare data from a MySQL database table against a CSV file, incorporating specific data cleaning steps like trimming whitespace and standardizing empty values to ensure accurate merging.
ECNU-ICALK
databases
sql-databases
304
etl-postgresql-dblink-do
Навык для разработки процедур на PL/pgSQL (DO-блоков), которые выполняют итерацию по данным, полученным через dblink, делают дополнительные выборки для каждого элемента, объединяют результаты и массово вставляют их в локальную таблицу.
ECNU-ICALK
databases
sql-databases
304
generate-sql-unpivot-queries-for-metric-tables
Use Python to generate SQL queries that unpivot multiple metric tables (sharing a date column) into a standardized long format (date, dimension, dimension_value, metric, metric_value) based on a JSON schema and SQL template.
ECNU-ICALK
databases
sql-databases
304
sqlalchemy-weekly-schedule-array-definition
Defines a 7x3 PostgreSQL ARRAY column in SQLAlchemy for a weekly schedule, containing open time, close time, and work time.
ECNU-ICALK
databases
sql-databases
304
gradio-mysql-dashboard-with-independent-chart
Develop a Gradio web application to search a MySQL database. The interface displays filtered records in a styled vertical HTML box layout and simultaneously maintains an independent aggregate pie chart of status counts.
ECNU-ICALK
databases
sql-databases
304
sql-query-generation-with-explicit-joins
Generate SQL queries using explicit JOIN syntax (INNER, LEFT, etc.) with ON clauses, strictly avoiding NATURAL JOIN to ensure compatibility.
ECNU-ICALK
databases
sql-databases
304
postgres-sql-generator-from-english
Generates PostgreSQL queries from plain English instructions, adhering to specific syntax rules for date functions and intervals.
ECNU-ICALK
databases
sql-databases
304
postgresql-inventory-tracking-schema-design
Design a PostgreSQL database schema for tracking item prices and stock counts, including immutable creation data and historical change logging.
ECNU-ICALK
databases