• Skip to main content
  • Skip to secondary menu
  • Skip to footer

Market Analysis

Connecting the Dots, Quantifying Technology Trends & Measuring Disruption

  • AI Market Analyzer
  • Tech News
    • Project Dashboard
  • Domain Marketplace
  • Sponsored Post
  • About
  • Contact

BareSQL Shows Who Can Read Every PostgreSQL Column and Where Your SQL Breaks Across Four Engines

November 12, 2026

Two questions come up in almost every company that runs SQL. Who can actually read this data? And will this query give the same answer somewhere else? Both usually get answered late, and by hand.

BareSQL is one small free program with two tools for them. BareSQL Audit lists every column each PostgreSQL login can read, the exact route that grants it, and which columns hold personal data. BareSQL Portable finds SQL that fails or returns a different answer on SQLite, PostgreSQL, MySQL and MariaDB, and suggests what to write instead.

The Pitch in Four Numbers

  • 2.6 seconds to audit 1,000 tables and 50 logins, sampling values, on 2 CPUs.
  • 69 SQL differences checked, each one run on all four engines.
  • 1,804 answers recorded from the real SQLite, PostgreSQL, MySQL and MariaDB engines.
  • 13 database server versions every change is tested on, PostgreSQL 13 to 18 among them.

BareSQL Audit

Working out who can read a sensitive column in PostgreSQL usually means hours in the catalog tables. Roles, inheritance, views, functions that run with their owner’s rights and row security all change the answer. The question keeps coming back: before every audit, and every time a new login appears, whether it’s for a contractor or an AI agent.

Audit answers it for every login at once. For each one it lists the columns it can read and the route that gets it there: a grant, a role membership, a view running with the owner’s rights, a default privilege. It marks personal data, and it saves results so the next audit can be compared with this one. Version 0.3.0 reads every database on a server in one run, since PostgreSQL roles belong to the whole server while tables belong to one database, and it reports what row security lets through.

The sample report, on a small shop database, finds two high and four medium findings, seven logins reading personal data and ten columns holding it. The headline finding is a newsletter table every role can read.

BareSQL Portable

Teams that test on SQLite and run PostgreSQL in production, or move from MySQL to PostgreSQL, find out late that the same query gives different answers. Seven divided by two is 3 on one engine and 3.5000 on another. NULLs sort to different ends. The project’s own posts are full of these: AVG returns four decimal places on MySQL and sixteen digits on PostgreSQL. COUNT with FILTER works on PostgreSQL and SQLite and fails on MySQL and MariaDB. GROUP BY counts Berlin and berlin as one city on MySQL and two on PostgreSQL. Column names like rank and key are reserved words on some engines.

Portable flags SQL like that before it ships. Its compare command runs a script on the real engines and reports every answer that differs. Every answer it quotes was recorded on all four engines, and the recordings live in the code repository. Version 0.2 added warnings for schema changes and reserved words that break on other engines.

How It’s Built

BareSQL is one file, written in Go with only the standard library. It installs nothing in your database and connects only to the databases you name. The compare feature calls the sqlite3 program, which macOS includes and Linux and Windows users install from the usual package sources.

Tests run on every change on Linux, macOS and Windows, against PostgreSQL 13 to 18, three MySQL versions and four MariaDB versions. Audit output is checked line by line against databases with planted leaks and near misses. An independent review covered both tools before the first release, and its findings were fixed or listed as known gaps in the README.

Who It’s For

  • Teams facing a security audit or a privacy review who need to show who can read personal data.
  • Anyone adding logins for contractors or AI agents who wants to know what that login can really see.
  • Developers who test on SQLite and ship on PostgreSQL, or the other way round.
  • Teams migrating between MySQL, MariaDB and PostgreSQL who want the differences up front.

Limits

Audit works only with PostgreSQL. Portable covers the four engines and the versions it’s tested on. It finds where SQL fails or differs. It doesn’t rewrite your queries for you, and it isn’t a general admin suite.

The Four-Question Screening

Every project featured here gets the same four questions, the way you’d screen a startup idea.

1. Where is the money in it?

Both tools are free under Apache 2.0, and there’s no paid tier yet. The money sits in compliance. Companies preparing for a SOC 2 audit, a GDPR review or a customer’s security questionnaire pay to prove who can read personal data, and they pay again every quarter. A paid version could keep audits on a schedule, track changes over time, produce reports an auditor accepts, and cover more databases than PostgreSQL. Migration projects are a second buyer: a portability check sold per migration, or bundled with consulting.

2. What real problem does it solve?

Two problems that cost real money when they’re found late. Access to sensitive columns piles up quietly through roles and views until nobody can say who sees what. And SQL that looks portable returns different numbers on a different engine, which turns into a wrong report or a failed migration in production.

3. The technology in plain words

Audit is like a building inspector who walks every corridor and writes down which keys open which rooms, including the side doors nobody remembers adding. Portable is like a proofreader for a book that will be printed by four different printers, each of which reads a few words differently. It runs the text through all four and marks every line that comes out different.

4. Moat and differentiation

Database security vendors sell big platforms, and migration tools sell conversions. BareSQL is small, local and specific: one file, nothing installed in the database, and answers backed by recordings from the real engines. That’s what earns trust with a database team. The moat that can grow is the library of recorded differences and the audit’s depth on PostgreSQL’s harder corners, the views, functions and row security, which take a long time to get right.

Why It Matters

More logins are touching production data than ever, and some of them now belong to AI agents. A fast, local answer to “who can read this column” is becoming routine hygiene. And as teams mix SQLite, PostgreSQL and MySQL across their stack, knowing where SQL quietly changes meaning saves a lot of bad surprises.

Follow the Project

Start with the quick start, look at the sample reports, read about Audit and Portable, or get the code from the BareSQL repository on GitHub. BareSQL is listed with the other open-source projects on SoftDevStudio.com, and more featured projects are in the Projects section.

Filed Under: Projects Tagged With: cybersecurity, enterprise software, startups and funding

Footer

Recent Posts

  • China Turns AI Model Distillation Into Industrial Policy and Weakens the Reach of US Chip Controls
  • AI-Found Software Flaws and the Rush to Patch Them Are Now a Market Risk After a Week of US Outages
  • Ohio Voters Put $17 Billion of Amazon Data Center Spending at Risk as Local Bans Spread
  • US Remote Access Chip Rule and FCC Optics Ban Squeeze Southeast Asia Data Centers and Nvidia China Exposure
  • Microsoft Puts Word, Excel and PowerPoint Inside Copilot and Turns Office Into an AI Front Door
  • OpenAI Cuts GPT-6.2 Astra Prices 20% as Microsoft MAI Code 2 Undercuts Frontier Coding Models
  • Tencent Q3 Shows New AI Products Cost About RMB15 Billion in Operating Profit as Capex Hits 39% of Revenue
  • Anthropic IPO Heads for the Top of Its Range as $900 Billion in Compute Commitments Go Public
  • Nvidia Q3 Revenue Hits $115.8 Billion but the Q4 Margin Guide Drops Three Points as the Board Rules Out Jensen Huang
  • Emboldened Iran and a Weakened Trump Leave US Stocks, Bonds and Oil Pricing a Peace That Has Not Arrived

RSS feed: Market Research Media Market Research Media

  • Four Vendor Surveys on Missed AI Returns Each Find the Problem Their Sponsor Sells a Fix For
  • Wasabi Study Puts Unplanned Infrastructure Spending at $63.4 Billion, With Germany Overspending by 7.1 Billion Euros
  • CSC Survey Finds 88% of Private Capital GPs Spend Up to Half Their Finance Time Checking Administrator Work
  • Lenovo Survey Finds 80% of IT Leaders Tie AI Success to the Digital Workplace and Only 10% Have Redesigned It
  • Claude and ChatGPT Integrations Killed the Headless CMS Market
  • Survey Margin of Error Explained, What Plus or Minus 3 Points Covers and What It Leaves Out
  • Morgan Stanley Pulse Survey Finds Bearish Investor Sentiment Rising to 42 Percent as Inflation Fears Grow
  • A Stronger Week Across the Network, October 4–10, 2026
  • The Tariff Map Is Becoming an Industrial Policy Map—and the U.S. Economy Is Paying the Price
  • PC Shipments Fall 22.4% as Higher Component Costs Price Buyers Out

Media Partners

  • Analysis
  • Technology Conferences
  • OSINT
  • Defense Market
  • Cybersecurity Market
  • Event Calendar
  • Calendarial
  • Opinion
  • 3V
  • Media Presser
  • Exclusive Domains

Copyright © 2026 MarketAnalysis.com | Terms of Service | Privacy Policy | Supplier Disclaimer | The Website Coded and Designed by SoftDev Studio

Media Partners: Technologies | Photography | Referently

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT