Results for “postgis”

Extends pandas for geospatial vector data analysis, including reading/writing shapefiles, GeoJSON, GeoPackage, and PostGIS, performing spatial joins, geometric operations, coordinate transformations, and creating static or interactive maps.

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

Provides PostgreSQL query patterns covering SELECT, JOINs, subqueries, CTEs, window functions, and advanced SQL techniques.

Optimize PostgreSQL queries, configure replication, and implement advanced database features with EXPLAIN analysis, JSONB operations, extension usage, and VACUUM tuning.

Quick reference for PostgreSQL best practices covering indexing, schema design, query optimization, and security defaults.

Manages AlloyDB for PostgreSQL clusters, instances, and backups using gcloud CLI commands.

Identifies Oracle-to-PostgreSQL migration risks by cross-referencing code against known behavioral differences. Use when planning a database migration, reviewing migration artifacts, or validating integration test coverage.

Review PostgreSQL code for best practices, anti-patterns, and quality standards including JSONB, arrays, custom types, schema design, functions, and security features like Row Level Security.

Analyze product data and manage product tooling in PostHog. Use when the user wants product analytics or insights, HogQL/SQL queries, feature flags, experiments and A/B tests, error tracking, session replay, surveys, LLM analytics, dashboards, data warehouse, or PostHog documentation.

Quick reference for PostgreSQL best practices covering query optimization, schema design, indexing, Row Level Security, and connection pooling.

Configures PostgreSQL replication including streaming, logical, cascading, delayed, failover, connection pooling, and backup with point-in-time recovery.

Streams change data capture from PostgreSQL into Redpanda or Kafka using Redpanda Connect's postgres_cdc input, covering setup, snapshotting, and troubleshooting.

Executa consultas, inspeção de schema e mutações seguras (DML/DDL com dry-run) no PostgreSQL via servidor MCP, exigindo confirmação explícita para alterações.

Design PostgreSQL schemas with best practices for data types, indexing, constraints, and performance patterns.

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

Diagnoses and tunes PostgreSQL performance issues such as slow queries, missing indexes, bloat, locks, and connection problems, providing SQL commands and best practices.

Run SQL queries and psql meta-commands against PostgreSQL databases via the psql CLI, with options for file execution, tuples-only output, and timeouts.

Creates an integration testing plan for .NET data access artifacts during Oracle-to-PostgreSQL database migrations, analyzing a project to identify repositories, DAOs, and service layers that interact with the database, then producing a structured testing plan.

Takes raw whole-genome sequencing FASTQ files or a pre-existing VCF through variant calling, quality control, and polygenic risk score computation using the PGS Catalog.

Expert guidance for Ibis, the Python dataframe library that provides a pandas-like API but generates SQL for execution on any backend — DuckDB, PostgreSQL, BigQuery, Snowflake, Spark, and more. Helps developers write analytics code once and run it anywhere without rewriting SQL for each database.

Extends pandas for geospatial vector data operations including reading/writing shapefiles, GeoJSON, and GeoPackage, performing spatial joins, coordinate transformations, and creating static or interactive maps.