Owner

mfvanek

6 indexed repositories · View on GitHub

pg-index-health
pg-index-health is an embeddable schema linter for PostgreSQL that detects common anti-patterns and promotes best practices.

Java · 202 stars
useful-sql-scripts
A set of useful PostgreSQL scripts

181 stars
pg-index-health-sql
pg-index-health-sql is a collection of SQL queries for analyzing PostgreSQL schemas, detecting issues and promoting best practices.

123 stars
java-experiments
Experiments with Java

Java · 9 stars
salary-calc
Demo app for salary calculation (Spring Boot)

Java · 8 stars
spring-boot-open-telemetry-demo
Spring Boot Open Telemetry Demo

Java · 6 stars

Beginner friendly Everything

Open All

Add testFixturesJavadoc to the CI pipeline Open

enhancement help wanted

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

mfvanek/pg-index-health#902 · Opened Sep 5, 2026
Revisit checkstyle config Open

enhancement

mfvanek/pg-index-health#901 · 1 assignee · Opened Sep 5, 2026
Fix Sonar code smells Open

enhancement

mfvanek/pg-index-health#900 · 1 assignee · Opened Sep 5, 2026
Migrate to Spring Boot 4.0.x Open

breaking change enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

mfvanek/pg-index-health#899 · Opened Sep 4, 2026
Add prefer-checks [Squawk] Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 55/100

mfvanek/pg-index-health#871 · Opened Jul 1, 2026
Try to group rules by categories Open

breaking change enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

mfvanek/pg-index-health#840 · Opened May 10, 2026
Update 'Hello Postgres cluster' example to replace deprecated `bitnamilegacy` image Open

Difficulty 1/5 Under an hour Newbie friendliness 88/100

mfvanek/useful-sql-scripts#15 · 2 comments · 1 reaction · Opened Mar 20, 2026
Take a look at pgrubic Open

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

mfvanek/pg-index-health#787 · 1 comment · Opened Jan 19, 2026
Idea: consider to add a check "mandatory-columns" and revisit PgContext and exceptions [schemalint] Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

mfvanek/pg-index-health#747 · Opened Nov 8, 2025
Add a check "prefer-text-with-check-to-enum" [schemalint] Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

mfvanek/pg-index-health#746 · Opened Nov 8, 2025
Add support for PostgreSQL 18 Open

enhancement good first issue help wanted

Difficulty 3/5 1-2 days Newbie friendliness 35/100

mfvanek/useful-sql-scripts#12 · Opened Sep 30, 2025
Performance of health logger Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

mfvanek/pg-index-health#717 · Opened Sep 27, 2025
Move all ApplicationContextInitializer into separate module Open

enhancement good first issue help wanted

Difficulty 4/5 3-5 days Newbie friendliness 25/100

mfvanek/spring-boot-open-telemetry-demo#287 · Opened Jul 5, 2025
Create a web site for a project Open

documentation enhancement

Difficulty 5/5 Over a week Newbie friendliness 20/100

mfvanek/pg-index-health#642 · Opened May 19, 2025
Add a check for cyclical relationships between tables [schemacrawler] Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 45/100

mfvanek/pg-index-health#632 · Opened May 6, 2025
Revisit Kafka configuration Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 15/100

mfvanek/spring-boot-open-telemetry-demo#242 · Opened Mar 13, 2025
Add a check "Candidates to convert btree index into hash index" Open

enhancement help wanted

Difficulty 4/5 3-5 days Newbie friendliness 35/100

mfvanek/pg-index-health#543 · Opened Dec 17, 2024
Rewrite query for "Index size/usage statistics" - remove second usage of schemaname Open

enhancement good first issue help wanted

Difficulty 2/5 1-3 hours Newbie friendliness 25/100

mfvanek/useful-sql-scripts#8 · Opened Dec 13, 2024
Consider to migrate from super-linter to sqlfluff-github-actions Open

enhancement

Difficulty 2/5 1-3 hours Newbie friendliness 38/100

mfvanek/pg-index-health-sql#61 · 3 comments · Opened Nov 26, 2024
Add example of logging inside scheduled operation Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 35/100

mfvanek/spring-boot-open-telemetry-demo#179 · Opened Nov 15, 2024
Optimize Hibernate statistics Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 15/100

mfvanek/java-experiments#218 · Opened Oct 2, 2024
Add example with tracing annotations like '@NewSpan' Open

Difficulty 3/5 1-2 days Newbie friendliness 30/100

mfvanek/spring-boot-open-telemetry-demo#155 · Opened Aug 9, 2024
Add tests for b3 headers propagation Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

mfvanek/spring-boot-open-telemetry-demo#151 · Opened Aug 4, 2024
Add Spring R2DBC integration Open

enhancement help wanted

Difficulty 5/5 Over a week Newbie friendliness 15/100

mfvanek/pg-index-health#416 · Opened Jun 6, 2024
Add Micronaut integration Open

enhancement help wanted

Difficulty 5/5 Over a week Newbie friendliness 20/100

mfvanek/pg-index-health#415 · Opened Jun 6, 2024
Compare current "B-tree indexes on array columns" with query by Kirill Borovikov Open

enhancement good first issue help wanted

Difficulty 4/5 3-5 days Newbie friendliness 38/100

mfvanek/pg-index-health-sql#43 · 4 comments · Opened May 4, 2024
Optimize Liquibase connection pool size Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

mfvanek/java-experiments#158 · Opened May 3, 2024
Disable JIT when running PostgreSQL in Docker Open

enhancement good first issue help wanted

Difficulty 3/5 1-2 days Newbie friendliness 35/100

mfvanek/useful-sql-scripts#7 · Opened Apr 23, 2024
Optimize connection to PostgreSQL Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

mfvanek/java-experiments#152 · 1 comment · Opened Apr 17, 2024
Idea: how to catch errors of the "missing index" class Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

mfvanek/pg-index-health#360 · 1 comment · Opened Mar 29, 2024
Add secondary DataSource with connection to another database Open

enhancement good first issue help wanted

Difficulty 5/5 Over a week Newbie friendliness 20/100

mfvanek/spring-boot-open-telemetry-demo#116 · 2 comments · Opened Feb 12, 2024
Add caching and Redis integration Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

mfvanek/spring-boot-open-telemetry-demo#112 · Opened Feb 3, 2024
Idea: check for alignment padding Open

enhancement help wanted

Difficulty 5/5 Over a week Newbie friendliness 25/100

mfvanek/pg-index-health#283 · 1 comment · Opened Sep 13, 2023
Improve integration with Testcontainers and add development time support Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

mfvanek/salary-calc#69 · 1 comment · Opened May 19, 2023
Fix native image Open

bug help wanted

Difficulty 4/5 3-5 days Newbie friendliness 25/100

mfvanek/salary-calc#60 · Opened Apr 24, 2023
Add micrometer instrumentation Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

mfvanek/pg-index-health#115 · 1 comment · Opened Nov 3, 2021
pg-index-health as cmd-utility Open

enhancement help wanted

Difficulty 5/5 Over a week Newbie friendliness 25/100

mfvanek/pg-index-health#46 · 5 comments · 2 reactions · Opened Mar 3, 2020

mfvanek

Get new issues in your inbox