Search Results for "postgres reporting tools"
Sort By:
Showing 41 open source projects for "postgres reporting tools"
View related business solutions-
Our Free Plans just got better! | Auth0You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
-
Stop Cyber Threats with VM-Series Next-Gen Firewall on AzureGain integrated visibility across all traffic in a single pass. Deploy Palo Alto Networks VM-Series to determine application identity and content while automating security policy updates via rich APIs.
-
1
Postgres Meta
A RESTful API for managing your Postgres. Fetch tables, add roles
Postgres Meta is a RESTful API for managing PostgreSQL databases, developed by Supabase. It allows users to perform administrative tasks such as creating tables, views, functions, roles, and extensions programmatically through HTTP endpoints. Postgres Meta enables developers to integrate database management directly into dashboards, automation tools, or backend services without requiring SQL access or pgAdmin. -
2
postgres_dba
The missing set of useful tools for Postgres DBAs and all engineers
postgres_dba is a collection of helpful SQL queries and scripts for PostgreSQL database administration. It provides ready-made insights into performance, storage, indexes, and configuration, helping DBAs quickly diagnose issues or monitor health. It's designed as a practical toolkit to keep in every Postgres admin’s back pocket. -
3
Stripe Sync Engine
Sync your Stripe account to you Postgres database
stripe-sync-engine is a tool by Supabase that continuously syncs Stripe data into a Postgres database using webhooks. It ensures that billing-related Stripe objects like customers, subscriptions, and invoices are always up to date in your local database. This makes it easy to run analytics, reporting, or custom business logic using SQL without hitting Stripe’s API repeatedly. -
4
Supabase
The open source Firebase alternative
Create a backend in less than 2 minutes. Start your project with a Postgres database, authentication, instant APIs, real-time subscriptions and storage. Every project is a full Postgres database, the world's most trusted relational database. Add user sign-ups and logins, securing your data with Row Level Security. Store, organize and serve large files. Any media, including videos and images. Write custom code and cron jobs without deploying or scaling servers. We introspect your database to... -
Secure File Transfer for Windows with Cerberus by RedwoodCerberus supports unlimited users and connections on a single IP, with built-in encryption, 2FA, and a browser-based web client — all deployable in under 15 minutes with a 25-day free trial.
-
5
pg_mooncake
Real-time analytics on Postgres tables
pg_mooncake is a PostgreSQL extension that brings observability and performance insights to your database by exposing low-level metrics and analytics. It provides developers with enhanced visibility into query execution, memory usage, and system behavior. Ideal for fine-tuning Postgres performance, pg_mooncake is designed for those who need actionable insights without external tools. -
6
pg_auto_failover
Postgres extension and service for automated failover
pg_auto_failover is a PostgreSQL extension and management tool for automated high availability. It handles health checks, failover, and monitoring without requiring third-party tools or complex configuration. Designed by the Citus Data team at Microsoft, it's ideal for developers and ops teams wanting reliable HA with minimal effort. -
7
Citus
Distributed PostgreSQL as an extension
Citus is a PostgreSQL extension that transforms Postgres into a distributed database, so you can achieve high performance at any scale. With Citus, you extend your PostgreSQL database with new superpowers. Distributed tables are sharded across a cluster of PostgreSQL nodes to combine their CPU, memory, storage and I/O capacity. References tables are replicated to all nodes for joins and foreign keys from distributed tables and maximum read performance. Distributed query engine routes and... -
8
pgcat
PostgreSQL pooler with sharding, load balancing and failover support
PgCat is a high-performance PostgreSQL connection pooler and load balancer built for modern, distributed systems. Written in Rust, PgCat is designed to efficiently manage database connections across multiple shards and replicas while supporting features like automatic failover, query-based routing, and observability. It works with both single-node and multi-tenant Postgres setups, making it ideal for cloud-native applications that require scale and reliability. -
9
pgCenter
Command-line admin tool for observing and troubleshooting Postgres
pgCenter is a command-line monitoring and troubleshooting tool for PostgreSQL, inspired by tools like top. It provides real-time insight into query activity, locks, I/O, and system resources directly from the terminal. With its interactive UI, pgCenter helps DBAs diagnose performance issues and manage server health without switching tools. -
AI-powered service management for IT and enterprise teamsGive your IT, operations, and business teams the ability to deliver exceptional services—without the complexity. Maximize operational efficiency with refreshingly simple, AI-powered Freshservice.
-
10
repmgr
A lightweight replication manager for PostgreSQL (Postgres)
repmgr is a management tool for PostgreSQL replication, providing monitoring, failover, and administrative capabilities for streaming replication setups. It simplifies the configuration of primary/standby clusters and automates failover processes for high availability. repmgr is widely used in production environments where database resilience and minimal downtime are critical. -
11
ParadeDB
ParadeDB is a modern Elasticsearch alternative built on Postgres
ParadeDB is an open-source search and analytics engine built on top of PostgreSQL. It serves as a modern alternative to Elasticsearch, offering real-time search capabilities for update-heavy workloads. By leveraging PostgreSQL's robustness, ParadeDB provides a scalable and efficient solution for full-text search and analytics. -
12
SQL Explorer
Easily share data across your company via SQL queries
...SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. SQL Explorer is inspired by any number of great query and reporting tools out there. -
13
PLpgSQL Check
plpgsql_check is a linter tool (does source code static analyze)
plpgsql_check is a PostgreSQL extension for static analysis and runtime checking of PL/pgSQL functions. It helps developers catch bugs early by analyzing code structure, variable usage, and SQL correctness before execution. The extension is ideal for improving code quality in large Postgres-based applications. -
14
SQL Notebook
SQL Notebook — Casual data exploration in SQL
SQL Notebook is a free Windows application for querying and analyzing data across multiple sources, including SQLite, PostgreSQL, Excel, and CSV files. It combines a SQL editor with a notebook interface, allowing for data exploration, transformation, and visualization in one place. SQL Notebook is ideal for analysts and data enthusiasts. -
15
Java 2D & 3D visual entity relationship design & modeling (ERD,SQL) for Oracle,MSSQL,Postgres,MySQL,...,Database change&dictionary management, Swing Data Binding, Apache FOP Renderer for dot matrix printers,Sparx Enterprise Architect Reports + more
-
16
Report Manager
Reporting tool, libraries and designer
Report Manager is both a print scheme designer (report) and a high level printing (reporting) engine. Also a TCP Report Server and a Web Report Server (PDF on the fly), supports Windows and Linux. Connectivity to almost all databases is provided. -
17
SIDU is a FREE database web GUI written in PHP. Handy and powerful for MySQL + PostgreSQL + SQLite + CUBRID. SIDU is simple and easy DB tool to use! SIDU has all features you need for database admin and web development. It's a great DB admin tool! No installation need. Best database front-end web based tools, cross platform looking no further
-
18
sentinel
Sentinel is a filesystem-backed document DBMS written in Rust.
...Data encryption supports AES-256-GCM, XChaCha20-Poly1305, and Ascon-128. Each document includes full audit metadata—creation timestamps, version history, hashes, and signatures—viewable with standard UNIX tools. Designed for edge deployments, compliance systems, audit logs, certificate management, and regulatory reporting. No server required, works entirely on filesystem with Git-based replication. Zero vendor lock-in—migrate anytime using standard tools like rsync, tar, or git. -
19
Aestel
Applications for data management
"Information is data in action", and, consequently, having good quality data is essential. The AESTEL package contains two highly configurable applications for data management: A data loader and a reporting application, i.e. DataLoader and AEREA, respectively. The data loader application applies user-defined instructions to validate, process and load data. The reporting application provides a query builder and spreadsheet template designer. Both applications work with any relational data model. (Postgres and Oracle have been tested). ... -
20
pgsh
Branch your PostgreSQL Database like Git
pgsh is a tool for managing multiple PostgreSQL environments by automating the setup of per-branch or per-developer databases. It makes it easy to clone production or staging schemas and spin up isolated dev instances tied to Git branches. pgsh is great for teams working on feature-heavy applications with parallel development workflows. -
21
M2SQL
Replicate your Mumps Globals into Relational Data Base
...Once mapping is completed you will able to replicate all the Mumps data into Target Relation database such as SQLITE or MYSQL. Normally you will do the replication process once a day while system is silent. This will give you a Relational Replication for Reporting or Business Analysis using industry standard tools. If you have a huge amount of data on your Mumps Globals you can choose an alternative mechanism in which only changes will be replicated to the target relational database and reflected almost immediately . The tool is a set of Mumps Routines and globals written on top of Intersystem IRIS , but using only pure Ansi standard Mumps . -
22
Open Source Data Quality and Profiling
World's first open source data quality & data preparation project
This project is dedicated to open source data quality and data preparation solutions. Data Quality includes profiling, filtering, governance, similarity check, data enrichment alteration, real time alerting, basket analysis, bubble chart Warehouse validation, single customer view etc. defined by Strategy. This tool is developing high performance integrated data management platform which will seamlessly do Data Integration, Data Profiling, Data Quality, Data Preparation, Dummy Data... -
23
xplordb
Open mineral exploration database system
Now also living on gitlab. https://gitlab.com/mds-/xplordb Mineral Exploration Database template/ system for Postgres/PostGIS and QGIS. The project incorporates import scripts, data storage, validation, reporting, 3D drill trace generation and more. psql, pgAdmin and QGIS are the suggested database and GIS front-end programs. -
24
TOra is a Toolkit for Oracle which aims to help the DBA or developer of database applications. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a full set of DBA tools. TOra also includes support for MySQL and Postgres.
-
25
CStore FDW
Columnar storage extension for Postgres
cstore_fdw is a columnar store extension for PostgreSQL built by Citus Data using the Foreign Data Wrapper (FDW) interface. It stores data in a compressed, columnar format that significantly reduces disk I/O for analytical queries. Ideal for read-heavy workloads and time-series data, cstore_fdw enhances Postgres’ ability to serve as a lightweight data warehouse.
