<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: merc3q65</title>
    <description>The latest articles on DEV Community by merc3q65 (@merc3q65).</description>
    <link>https://dev.to/merc3q65</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3736040%2Ff1ec2026-1b9d-4090-9f41-91952559f28e.png</url>
      <title>DEV Community: merc3q65</title>
      <link>https://dev.to/merc3q65</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/merc3q65"/>
    <language>en</language>
    <item>
      <title>I Built a Postgres Proxy That Masks PII for AI Agents</title>
      <dc:creator>merc3q65</dc:creator>
      <pubDate>Tue, 27 Jan 2026 20:49:03 +0000</pubDate>
      <link>https://dev.to/merc3q65/i-built-a-postgres-proxy-that-masks-pii-for-ai-3i32</link>
      <guid>https://dev.to/merc3q65/i-built-a-postgres-proxy-that-masks-pii-for-ai-3i32</guid>
      <description>&lt;p&gt;I'm building AI agents that need database access. Problem is, one bad prompt and it's &lt;code&gt;DELETE FROM users WHERE 1=1&lt;/code&gt;.      &lt;/p&gt;

&lt;p&gt;So I built &lt;strong&gt;AXP&lt;/strong&gt; - a proxy that sits between your agent and Postgres.                                                   &lt;/p&gt;

&lt;p&gt;## What it does                                                                                                           &lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Agent sees &lt;code&gt;j***@gmail.com&lt;/code&gt; instead of real emails
&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;DROP TABLE&lt;/code&gt; gets blocked before it reaches the DB
&lt;/li&gt;
&lt;li&gt;Rate limits to prevent runaway queries
&lt;/li&gt;
&lt;li&gt;Full audit log of everything
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;## Demo                                                                                                                   &lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F6soeb3ca3t7v0n0mxsao.gif" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F6soeb3ca3t7v0n0mxsao.gif" alt="AXP Demo" width="800" height="450"&gt;&lt;/a&gt;                                          &lt;/p&gt;

&lt;p&gt;## How it works                                                                                                           &lt;/p&gt;

&lt;p&gt;Your agent connects to AXP instead of Postgres directly. Define permissions in YAML:                                      &lt;/p&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;
yaml                                                                                                                   
  spec:                                                                                                                     
    permissions:                                                                                                            
      - resource: database/postgres/mydb                                                                                    
        actions: [READ]                                                                                                     
        tables: [users, orders]                                                                                             
        mask:                                                                                                               
          - column: email                                                                                                   
            pattern: partial                                                                                                
    safety:                                                                                                                 
      blocked_patterns:                                                                                                     
        - "DROP TABLE"                                                                                                      

  Zero code changes. Any Postgres client works.                                                                             

[Github](https://github.com/AXP-Core/axp)

  Would love feedback!                                    
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;

</description>
      <category>ai</category>
      <category>postgres</category>
      <category>security</category>
      <category>opensource</category>
    </item>
  </channel>
</rss>
