HariSekhon / SQL-scriptsLinks
100+ SQL Scripts - PostgreSQL, MySQL, Oracle, Google BigQuery, MariaDB, AWS Athena. DBA, Analytics, DevOps, performance engineering. Google BigQuery ML machine learning classification.
☆453Updated 6 months ago
Alternatives and similar repositories for SQL-scripts
Users that are interested in SQL-scripts are comparing it to the libraries listed below
Sorting:
- PG Collector for Postgresql is a sql script that gathers valuable database information and presents it in a consolidated HTML file which …☆113Updated 9 months ago
- PostgreSQL DBA scripts☆70Updated 4 years ago
- Query Performance Monitoring Tool for PostgreSQL☆526Updated this week
- PostgreSQL Monitoring, Metrics Collection and Alerting Resources from Crunchy Data☆673Updated 2 weeks ago
- Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.☆217Updated this week
- This repository contains a number of UNIX scripts, and PostgreSQL queries. The author, Melvin Davidson, originally distributed them on th…☆51Updated 10 years ago
- PostgreSQL ASH Viewer (PASH Viewer) provides graphical view of active session history data within the PostgreSQL database☆125Updated 3 years ago
- Postgres historic workload reports☆277Updated this week
- A curated list of awesome PostgreSQL software, libraries, tools and resources, forked from dhamaniasad/awesome-postgres☆175Updated last year
- Postgres features showcase (commented SQL samples) for beginners☆167Updated 5 years ago
- Collect and display information and stats from a running PostgreSQL server☆1,009Updated 3 weeks ago
- PostgreSQL Remote Control☆491Updated 3 months ago
- Copy a Postgres database to a target Postgres server (pg_dump | pg_restore on steroids)☆1,353Updated 4 months ago
- The missing set of useful tools for Postgres DBAs and all engineers☆1,196Updated last month
- Queries to mesure statistical bloat in indexes and tables for PostgreSQL☆556Updated 3 years ago
- Sample databases for postgres☆537Updated 2 years ago
- Advanced PostgreSQL & Pgbouncer Metrics Exporter for Prometheus☆270Updated last month
- A simple set of views to see ALL permissions in a PostgreSQL database☆158Updated last month
- postgresql extension providing Active session history☆182Updated last month
- 80+ DevOps & Data CLI Tools - AWS, GCP, GCF Python Cloud Functions, Log Anonymizer, Spark, Hadoop, HBase, Hive, Impala, Linux, Docker, Sp…☆806Updated 4 months ago
- ASH Viewer provides a graphical view of active session history data within the Oracle and PostgreSQL DB☆187Updated last year
- pgCompare – a straightforward utility crafted to simplify the data comparison process, providing a robust solution for comparing data acr…☆168Updated last month
- Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication …☆1,152Updated last month
- pg_timetable: Advanced scheduling for PostgreSQL☆1,204Updated 2 weeks ago
- PostgreSQL metrics monitor/dashboard☆1,838Updated 9 months ago
- The PostgreSQL Sample Database☆64Updated 3 months ago
- Presentation materials for the Annotated.Conf Tutorial☆275Updated 7 years ago
- Backup and recovery manager for PostgreSQL☆751Updated 2 weeks ago
- Postgres HowTo articles☆181Updated 10 months ago
- Utility for automatical rebuild bloated indexes (a-la smart autovacuum to deal with index bloat) in PostgreSQL.☆62Updated 4 months ago