<?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: WaterShow</title>
    <description>The latest articles on DEV Community by WaterShow (@watershow).</description>
    <link>https://dev.to/watershow</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.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4206643%2F2c1b57c7-fecb-4907-99a7-0b67c18b3946.png</url>
      <title>DEV Community: WaterShow</title>
      <link>https://dev.to/watershow</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/watershow"/>
    <language>en</language>
    <item>
      <title>How to search Hacker News using the free Algolia API</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Wed, 18 Nov 2026 13:17:11 +0000</pubDate>
      <link>https://dev.to/watershow/how-to-search-hacker-news-using-the-free-algolia-api-2kg8</link>
      <guid>https://dev.to/watershow/how-to-search-hacker-news-using-the-free-algolia-api-2kg8</guid>
      <description>&lt;p&gt;Hacker News is useful to track trends, find mentions of your product, or read discussions. Scraping the HTML directly can get your IP address blocked.&lt;/p&gt;

&lt;p&gt;You can use the free Algolia Hacker News API. It provides a JSON interface to search through stories and comments without needing an API key.&lt;/p&gt;

&lt;h2&gt;
  
  
  The base URL and endpoints
&lt;/h2&gt;

&lt;p&gt;Algolia hosts the official search for Hacker News. The API has two main endpoints.&lt;/p&gt;

&lt;p&gt;For the most relevant results for a keyword, use the standard search endpoint at &lt;code&gt;https://hn.algolia.com/api/v1/search&lt;/code&gt;. For the newest mentions, use &lt;code&gt;https://hn.algolia.com/api/v1/search_by_date&lt;/code&gt;. Both endpoints accept a query string parameter called &lt;code&gt;query&lt;/code&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  Filtering by stories or comments
&lt;/h2&gt;

&lt;p&gt;Hacker News has different types of items like stories, comments, polls, and job postings. You can restrict your search using the &lt;code&gt;tags&lt;/code&gt; parameter.&lt;/p&gt;

&lt;p&gt;To search only the main submissions, add &lt;code&gt;tags=story&lt;/code&gt; to your URL. To find mentions in threads, use &lt;code&gt;tags=comment&lt;/code&gt;. You can also filter by a specific author using &lt;code&gt;tags=author_username&lt;/code&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  Setting a minimum point threshold
&lt;/h2&gt;

&lt;p&gt;The API allows you to use numeric filters to return items that meet certain criteria.&lt;/p&gt;

&lt;p&gt;Pass a &lt;code&gt;numericFilters&lt;/code&gt; parameter to set conditions on fields like points or number of comments. Passing &lt;code&gt;numericFilters=points&amp;gt;50&lt;/code&gt; returns submissions with more than 50 points. You can chain these together by passing multiple filters separated by a comma.&lt;/p&gt;

&lt;h2&gt;
  
  
  A simple Node.js fetch script
&lt;/h2&gt;

&lt;p&gt;Here is a TypeScript script that pulls recent stories mentioning a specific topic with more than 20 points. You can run this with Node.js.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight typescript"&gt;&lt;code&gt;&lt;span class="k"&gt;async&lt;/span&gt; &lt;span class="kd"&gt;function&lt;/span&gt; &lt;span class="nf"&gt;searchHackerNews&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;keyword&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kt"&gt;string&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;baseUrl&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s1"&gt;'https://hn.algolia.com/api/v1/search_by_date'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;params&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;new&lt;/span&gt; &lt;span class="nc"&gt;URLSearchParams&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="n"&gt;query&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;keyword&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;tags&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s1"&gt;'story'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;numericFilters&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s1"&gt;'points&amp;gt;20'&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

  &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;response&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;await&lt;/span&gt; &lt;span class="nb"&gt;fetch&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sb"&gt;`${baseUrl}?${params.toString()}`&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

  &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="o"&gt;!&lt;/span&gt;&lt;span class="n"&gt;response&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;ok&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="k"&gt;throw&lt;/span&gt; &lt;span class="k"&gt;new&lt;/span&gt; &lt;span class="nb"&gt;Error&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sb"&gt;`API error: ${response.statusText}`&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;

  &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;data&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;await&lt;/span&gt; &lt;span class="n"&gt;response&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;json&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

  &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;hit&lt;/span&gt; &lt;span class="k"&gt;of&lt;/span&gt; &lt;span class="n"&gt;data&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;hits&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="nb"&gt;console&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;log&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sb"&gt;`[${hit.points} pts] ${hit.title}`&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
    &lt;span class="nb"&gt;console&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;log&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sb"&gt;`URL: ${hit.url || 'No external link'}`&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
    &lt;span class="nb"&gt;console&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;log&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sb"&gt;`HN Link: https://news.ycombinator.com/item?id=${hit.objectID}\n`&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="nf"&gt;searchHackerNews&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s1"&gt;'supabase'&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Things that bit me
&lt;/h2&gt;

&lt;p&gt;The API does not require authentication, but it does rate limit you based on your IP address. If you run a script that polls too aggressively, you will start getting 429 Too Many Requests errors.&lt;/p&gt;

&lt;p&gt;Algolia caps the pagination at 1000 hits per query. If your search matches 50,000 comments, you can only page through the first 1000 results unless you narrow the time window using numeric filters on the &lt;code&gt;created_at_i&lt;/code&gt; field.&lt;/p&gt;

&lt;p&gt;The &lt;code&gt;url&lt;/code&gt; field in the response is sometimes null. Text-only posts, like Ask HN or Show HN submissions, do not have an external link, so you have to handle that missing property in your code.&lt;/p&gt;

&lt;p&gt;If you need help building scrapers or connecting APIs, check out &lt;a href="https://dev.to/tools"&gt;other things I build&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  How do I search for newest results instead of relevant ones?
&lt;/h3&gt;

&lt;p&gt;You use the search_by_date endpoint instead of the standard search endpoint. The base URL for this is &lt;a href="https://hn.algolia.com/api/v1/search_by_date" rel="noopener noreferrer"&gt;https://hn.algolia.com/api/v1/search_by_date&lt;/a&gt;.&lt;/p&gt;

&lt;h3&gt;
  
  
  How do I find comments instead of stories?
&lt;/h3&gt;

&lt;p&gt;You pass the tags parameter in your API request. Setting it to tags=comment will restrict the results to only return comments.&lt;/p&gt;

&lt;h3&gt;
  
  
  Why can I only see the first 1000 results?
&lt;/h3&gt;

&lt;p&gt;Algolia restricts the pagination on this API to 1000 hits maximum per query. To see more, you must narrow down your search using date filters.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/search-hacker-news-algolia-api" rel="noopener noreferrer"&gt;watershowdigital.com/blog/search-hacker-news-algolia-api&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>api</category>
      <category>javascript</category>
      <category>dataextraction</category>
    </item>
    <item>
      <title>New tools for self-hosting and managing AI agents</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Fri, 13 Nov 2026 13:56:11 +0000</pubDate>
      <link>https://dev.to/watershow/new-tools-for-self-hosting-and-managing-ai-agents-13f3</link>
      <guid>https://dev.to/watershow/new-tools-for-self-hosting-and-managing-ai-agents-13f3</guid>
      <description>&lt;p&gt;Managing coding agents, tracking their context across machines, and preventing outdated code are new challenges. &lt;/p&gt;

&lt;p&gt;New tools let you run, sync, and correct agents locally or on your servers. Here is a look at what is available for self-hosting and managing AI agents.&lt;/p&gt;

&lt;h2&gt;
  
  
  Self-hosted Claude Managed Agents
&lt;/h2&gt;

&lt;p&gt;Anthropic added a self-hosted option to the &lt;a href="https://docs.claude.com/en/release-notes/api" rel="noopener noreferrer"&gt;Claude API&lt;/a&gt;. You run the Managed Agents service on your infrastructure. You store the agents, sessions, and session history locally on your servers.&lt;/p&gt;

&lt;p&gt;The local server sends model requests to a provider you choose. Anthropic is the default provider. Organization admins can turn off web fetch for their organization in the console settings. With web fetch turned off, requests that include the tool fail with a 400 error. The web fetch tool follows domain restrictions set by the organization.&lt;/p&gt;

&lt;p&gt;The API update also introduced Claude Fable 5.2 and Claude Mythos 5.2. Both models have a 1M token context window and 128k max output tokens. They read other models' thinking blocks on the Claude API, allowing a conversation to switch models and keep its reasoning.&lt;/p&gt;

&lt;h2&gt;
  
  
  AgentRun: A managed platform for open-source agents
&lt;/h2&gt;

&lt;p&gt;Agents often rediscover the same API and reread the same docs for repeated tasks. &lt;a href="https://github.com/Parcha-ai/agentrun/blob/main/README.md" rel="noopener noreferrer"&gt;AgentRun&lt;/a&gt; is an open-source platform built by GREP.AI that adds durable execution to agent harnesses like Claude Code, Codex, OpenCode, or pi. &lt;/p&gt;

&lt;p&gt;At the end of every run, the agent proposes notes, skills, or workflows to keep. Code checks the proposals, a grader judges them, and AgentRun commits the passing items to the agent's git folder. The next run starts with this learned context.&lt;/p&gt;

&lt;p&gt;Every run lives in a single store. If you stop the server mid-run and start it again, the run carries on. You can give agents specific environments like a Linux sandbox, a desktop, an Android phone, or a browser. &lt;/p&gt;

&lt;p&gt;You can configure tools to ask for approval first, and the run waits in the console until you answer. You configure your model keys in the project settings. You can run the server and one runner locally on port 7340 with this command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;npx @parcha/agentrun
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Atuin Threads: Syncing agent sessions
&lt;/h2&gt;

&lt;p&gt;Agent sessions store every command, output, and attempt you make while solving a problem. &lt;a href="https://blog.atuin.sh/threads-agent-sessions/" rel="noopener noreferrer"&gt;Atuin Threads&lt;/a&gt; syncs your agent sessions across machines.&lt;/p&gt;

&lt;p&gt;You can start a task in Claude Code on a development server and finish it in Codex on your laptop. Atuin uses an end-to-end encrypted sync engine. It works with Claude Code, Codex, Pi, Omp, and OpenCode. &lt;/p&gt;

&lt;p&gt;Agents can search and reference previous sessions using the Atuin Model Context Protocol. They can find past work and understand decisions. &lt;/p&gt;

&lt;p&gt;You can install Atuin using this command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;curl --proto &lt;span class="s1"&gt;'=https'&lt;/span&gt; --tlsv1.2 -LsSf https://setup.atuin.sh &lt;span class="o"&gt;|&lt;/span&gt; sh
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;You run &lt;code&gt;atuin resume&lt;/code&gt; to access the interface. To give your agents access to the history, you install the protocol server:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;atuin mcp install
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Guide: Modernizing your coding agents
&lt;/h2&gt;

&lt;p&gt;Coding agents frequently write bloated JavaScript for tasks that modern browsers handle natively. &lt;a href="https://github.com/GoogleChrome/modern-web-guidance" rel="noopener noreferrer"&gt;Modern Web Guidance&lt;/a&gt; injects modern platform expertise into coding agents.&lt;/p&gt;

&lt;p&gt;The tool provides targeted guidelines that help agents use modern features like CSS highlights, dialog backdrops, and auto-sizing textareas instead of legacy libraries.&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Install Modern Web Guidance using the interactive wizard in your terminal.
&lt;/li&gt;
&lt;/ol&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;npx modern-web-guidance@latest install
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;ol&gt;
&lt;li&gt;Search for relevant guides directly from the command line without installing.
&lt;/li&gt;
&lt;/ol&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;npx modern-web-guidance@latest search &lt;span class="s2"&gt;"animate a dialog modal backdrop"&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;ol&gt;
&lt;li&gt;Retrieve a specific guide by its identifier to feed into your agent.
&lt;/li&gt;
&lt;/ol&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;npx modern-web-guidance@latest retrieve &lt;span class="s2"&gt;"animate-to-from-top-layer"&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;ol&gt;
&lt;li&gt;Scan your current codebase to find legacy patterns that the tool can help modernize.
&lt;/li&gt;
&lt;/ol&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;npx modern-web-guidance@latest legacy-scan .
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  The catch
&lt;/h2&gt;

&lt;p&gt;Self-hosted Claude Managed Agents are not available to everyone by default. You must contact your Anthropic account team to request access. &lt;/p&gt;

&lt;p&gt;AgentRun requires Node 24.22.3 or newer, and it only runs on macOS or Linux. If Docker is running, new agents get a Docker sandbox, but the image takes a few minutes to build on the first use. If you use remote computers like Daytona or Browserbase in AgentRun, billing goes through your own account with those vendors.&lt;/p&gt;

&lt;p&gt;The Atuin Model Context Protocol only supports a specific list of agent harnesses. If you use an unsupported harness, the agent cannot query your synced session history automatically.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  How do I install AgentRun?
&lt;/h3&gt;

&lt;p&gt;You can start AgentRun locally by running &lt;code&gt;npx @parcha/agentrun&lt;/code&gt; in your terminal. This command starts the server and one runner on port 7340. It keeps all data in a local folder and opens the console in your browser.&lt;/p&gt;

&lt;h3&gt;
  
  
  Which agents does Atuin Threads support?
&lt;/h3&gt;

&lt;p&gt;Atuin Threads currently supports Claude Code, Codex, Pi, Omp, and OpenCode. You can resume sessions from these agents across different machines. The sessions are synced using end-to-end encryption.&lt;/p&gt;

&lt;h3&gt;
  
  
  What is Modern Web Guidance?
&lt;/h3&gt;

&lt;p&gt;Modern Web Guidance is a set of skills and guidelines that teach coding agents to use native browser features instead of legacy JavaScript. You can install it or use its command line interface to search for specific web patterns.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/self-hosted-ai-agent-tools" rel="noopener noreferrer"&gt;watershowdigital.com/blog/self-hosted-ai-agent-tools&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>agents</category>
      <category>claude</category>
      <category>javascript</category>
    </item>
    <item>
      <title>How to safely connect an OpenAI Custom GPT to the Shopify API</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Wed, 11 Nov 2026 13:30:46 +0000</pubDate>
      <link>https://dev.to/watershow/how-to-safely-connect-an-openai-custom-gpt-to-the-shopify-api-3nap</link>
      <guid>https://dev.to/watershow/how-to-safely-connect-an-openai-custom-gpt-to-the-shopify-api-3nap</guid>
      <description>&lt;p&gt;You built a Custom GPT to act as a customer support agent or internal assistant. You want it to check inventory or create draft orders, so you create an Action in OpenAI. Most tutorials tell you to generate a Shopify Admin API token and paste it directly into the GPT authentication settings. &lt;/p&gt;

&lt;p&gt;This works, but it puts your entire store at risk. A Custom GPT is a chatbot wrapped around an API client. If you give it your main Shopify key, anyone talking to that GPT might be able to steal the key and take control of your store.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Prompt injection exposing the headers
&lt;/h2&gt;

&lt;p&gt;Users can tell a GPT to ignore its previous instructions. They can type a prompt asking the AI to print the exact HTTP headers it sends when making an API request. Since OpenAI injects your Shopify token into those headers to authenticate the action, the GPT will often just print your raw token on the screen. &lt;/p&gt;

&lt;p&gt;Once a malicious user has your Shopify Admin API token, they have the same access your GPT does. If the token has broad permissions, the user can download your customer list, delete products, or change prices directly via the Shopify API.&lt;/p&gt;

&lt;p&gt;Fix: Put a middleman between OpenAI and Shopify. This is usually a small piece of code running on Cloudflare Workers, Vercel, or a basic Node.js server. You give this middleware server your real Shopify Admin token. You store it securely as an environment variable so it never reaches the browser or the OpenAI servers. Then, you invent a new, random password. You give this random password to the Custom GPT in the &lt;strong&gt;Authentication&lt;/strong&gt; settings. &lt;/p&gt;

&lt;h2&gt;
  
  
  2. Unrestricted API access
&lt;/h2&gt;

&lt;p&gt;If your middleware just takes whatever the GPT sends and forwards it to Shopify, you still have a problem. The AI might hallucinate a destructive command, or a user might trick the AI into passing a delete command through your middleware. &lt;/p&gt;

&lt;p&gt;Fix: Hardcode the allowed actions. Do not let the GPT send raw GraphQL or REST queries. Instead, write specific endpoints on your middleware. &lt;/p&gt;

&lt;p&gt;Create an endpoint like &lt;code&gt;/get-stock-level&lt;/code&gt;. Tell the Custom GPT to send a product ID to that endpoint. Have your middleware read the product ID and construct the exact Shopify API call needed to fetch the stock. Return only the stock number to the GPT.&lt;/p&gt;

&lt;p&gt;This guarantees the AI can only perform the actions you explicitly programmed. Even if the user tricks the GPT, the GPT can only hit the &lt;code&gt;/get-stock-level&lt;/code&gt; endpoint. &lt;/p&gt;

&lt;h2&gt;
  
  
  3. Dealing with a leaked middleware password
&lt;/h2&gt;

&lt;p&gt;If a user tricks the GPT into printing its headers after you set up middleware, they will only see the random password you invented. Your Shopify store remains safe because the real token is hidden on your server.&lt;/p&gt;

&lt;p&gt;However, the user could still use that random password to spam your middleware endpoints outside of ChatGPT. &lt;/p&gt;

&lt;p&gt;Fix: Revoke the middleware password. Since you control the middleware, you generate a new random password, update your server environment variables, and paste the new password into the OpenAI action settings. The attacker's access is cut off, and your Shopify integration does not need to be rebuilt.&lt;/p&gt;

&lt;h2&gt;
  
  
  Still stuck?
&lt;/h2&gt;

&lt;p&gt;Setting up a middleware server requires writing code and managing hosting. If you need a secure bridge between your AI tools and your database, &lt;a href="https://dev.to/build"&gt;this is the kind of fix I do&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  Can a Custom GPT hide its API keys?
&lt;/h3&gt;

&lt;p&gt;No, the API keys stored in a Custom GPT action can often be revealed through prompt injection. You should never put a high-privilege API token directly into OpenAI.&lt;/p&gt;

&lt;h3&gt;
  
  
  Why shouldn't I use the Shopify Admin API directly in OpenAI?
&lt;/h3&gt;

&lt;p&gt;The Shopify Admin API token gives direct control over your store data. If the GPT leaks this token, an attacker can read your customer data or modify your products.&lt;/p&gt;

&lt;h3&gt;
  
  
  What is middleware for an API?
&lt;/h3&gt;

&lt;p&gt;Middleware is a small server you control that sits between two services. It receives the request from the first service, validates it, and then forwards it to the second service using hidden credentials.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/safely-connect-openai-custom-gpt-shopify-api" rel="noopener noreferrer"&gt;watershowdigital.com/blog/safely-connect-openai-custom-gpt-shopify-api&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>shopify</category>
      <category>openai</category>
      <category>api</category>
      <category>security</category>
    </item>
    <item>
      <title>Claude Fable 5.2, Muse Ember, and new Lovable integrations</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Tue, 10 Nov 2026 15:55:29 +0000</pubDate>
      <link>https://dev.to/watershow/claude-fable-52-muse-ember-and-new-lovable-integrations-4i8k</link>
      <guid>https://dev.to/watershow/claude-fable-52-muse-ember-and-new-lovable-integrations-4i8k</guid>
      <description>&lt;p&gt;Anthropic launched Claude Fable 5.2, and Meta released Muse Ember. Web app generation platforms also added new integrations to connect code to external tools.&lt;/p&gt;

&lt;p&gt;These updates affect how you run automated coding tasks and build single-page apps. You must also monitor how automated coding tools handle database keys to prevent leaks. &lt;/p&gt;

&lt;h2&gt;
  
  
  Claude Fable 5.2 arrives on the API and GitHub Copilot
&lt;/h2&gt;

&lt;p&gt;Anthropic released Claude Fable 5.2. According to the release notes from the &lt;a href="https://docs.claude.com/en/release-notes/api" rel="noopener noreferrer"&gt;Claude API&lt;/a&gt;, the model supports a 1M token context window and up to 128k output tokens. It costs $8 USD per million input tokens and $40 USD per million output tokens. Fast mode allows up to 2.5 times higher output tokens per second, costing $16 USD for input and $80 USD for output per million tokens. &lt;/p&gt;

&lt;p&gt;The model enforces a prefix check for every account. If your code edits a system prompt and sends back a thinking block from a later turn, the request returns a 400 error. The model also supports computer use via the newer toolset. Older computer use toolsets will return an error on most platforms. &lt;/p&gt;

&lt;p&gt;According to the &lt;a href="https://github.blog/changelog/2026-11-09-claude-fable-5-2-in-github-copilot" rel="noopener noreferrer"&gt;Claude Fable 5.2 in GitHub Copilot&lt;/a&gt; announcement, the model is available for Copilot Pro+, Max, Business, and Enterprise users. You can select it in the model picker in tools like Visual Studio Code.&lt;/p&gt;

&lt;h2&gt;
  
  
  Meta Muse Ember for repetitive agent tasks
&lt;/h2&gt;

&lt;p&gt;As reported in &lt;a href="https://www.marktechpost.com/2026/11/09/meta-muse-ember-small-agent-model/" rel="noopener noreferrer"&gt;Meta Releases Muse Ember, a 1M-Context Model for High-Volume Agent Work&lt;/a&gt;, this is Meta's hosted multimodal reasoning model targeting repetitive steps inside agent workflows like tool calls, routing, and long document parsing.&lt;/p&gt;

&lt;p&gt;Muse Ember has a 1M token context window and generates up to 512K output tokens. It runs on Meta's hosted infrastructure through the Meta Model API and Muse Code. Meta estimates the cost at about $0.14 per index task. It scores a 36 on the Artificial Analysis Intelligence Index.&lt;/p&gt;

&lt;h2&gt;
  
  
  Lovable adds Jira and Mailjet connectors
&lt;/h2&gt;

&lt;p&gt;Based on the &lt;a href="https://docs.lovable.dev/changelog" rel="noopener noreferrer"&gt;Lovable&lt;/a&gt; changelog, you can now add Jira and Mailjet connectors directly to your projects. &lt;/p&gt;

&lt;p&gt;The Jira connector lets your app search, create, and update issues on a Jira Cloud site. The Mailjet connector lets apps send transactional emails from a validated sender, add contacts, and read delivery status.&lt;/p&gt;

&lt;p&gt;When you build apps in Lovable or Bolt, they are Vite and React single page apps connected to Supabase. There is no Next.js in them unless you add it. Client environment variables must start with VITE_ to work in the browser. Do not use NEXT_PUBLIC_ for a Vite app. &lt;/p&gt;

&lt;h2&gt;
  
  
  Preventing credential leaks with coding agents
&lt;/h2&gt;

&lt;p&gt;A report on &lt;a href="https://apiiro.com/blog/coding-agents-leaking-secrets-github-dont-ask-again" rel="noopener noreferrer"&gt;Claude Code's "Don't Ask Again" exposes passwords in 1,122 public GitHub files&lt;/a&gt; highlights how developers accidentally pushed sensitive data to public repositories using coding agents.&lt;/p&gt;

&lt;p&gt;When you use automated tools to build web apps, you must separate your public keys from your secret keys. For example, if you build a Next.js app, client environment variables start with NEXT_PUBLIC_ and are inlined at build time. Changing them requires a redeploy. &lt;/p&gt;

&lt;p&gt;The Supabase service_role key has full database access and bypasses row level security. This key must never reach the browser. Keep it out of your client side code and ensure your coding agent does not write it into public configuration files. &lt;/p&gt;

&lt;p&gt;For authentication, Supabase OAuth providers like Google or GitHub require a specific callback URL. The provider gets the callback formatted as &lt;code&gt;https://&amp;lt;project-ref&amp;gt;.supabase.co/auth/v1/callback&lt;/code&gt;. You configure your own domains in Supabase by going to &lt;strong&gt;Authentication&lt;/strong&gt; &amp;gt; &lt;strong&gt;URL Configuration&lt;/strong&gt; and adjusting the &lt;strong&gt;Site URL&lt;/strong&gt; and &lt;strong&gt;Redirect URLs&lt;/strong&gt;. &lt;/p&gt;

&lt;h2&gt;
  
  
  The catch
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Claude Fable 5.2 requires 30 day data retention by default to operate safety classifiers. The retained data is not used to train models, but you cannot use zero data retention unless expressly authorized by Anthropic.&lt;/li&gt;
&lt;li&gt;In GitHub Copilot, Copilot Enterprise and Business administrators must manually enable the Claude Fable 5.2 policy in the settings.&lt;/li&gt;
&lt;li&gt;Topaz Starlight Fast 2, available for Lovable AI features, restores video clips in the background and can take hours to finish.&lt;/li&gt;
&lt;li&gt;Meta Muse Ember is only available on Meta's hosted infrastructure. You cannot run the weights locally on your own hardware.&lt;/li&gt;
&lt;li&gt;In Lovable, the new GPT Image 2.6 models and GPT-6.1 Terra are not available while EU inference is enabled.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  What are the context limits for Claude Fable 5.2 and Meta Muse Ember?
&lt;/h3&gt;

&lt;p&gt;Both Claude Fable 5.2 and Meta Muse Ember feature a 1M token context window. Claude Fable 5.2 supports up to 128k output tokens, while Meta Muse Ember supports up to 512k output tokens. &lt;/p&gt;

&lt;h3&gt;
  
  
  How do I use the new Claude Fable 5.2 model in GitHub Copilot?
&lt;/h3&gt;

&lt;p&gt;You can select Claude Fable 5.2 in the model picker inside your editor, such as Visual Studio Code. If you are on an Enterprise or Business plan, an administrator must first enable the model policy in the settings.&lt;/p&gt;

&lt;h3&gt;
  
  
  How do environment variables work in Lovable apps?
&lt;/h3&gt;

&lt;p&gt;Lovable apps are built with Vite and React, so client environment variables must start with VITE_. Variables starting with NEXT_PUBLIC_ are used for Next.js apps and will not work in standard Lovable projects.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/claude-fable-muse-ember-lovable-updates" rel="noopener noreferrer"&gt;watershowdigital.com/blog/claude-fable-muse-ember-lovable-updates&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>claude</category>
      <category>lovable</category>
      <category>aiagents</category>
      <category>security</category>
    </item>
    <item>
      <title>How to handle prefers-reduced-motion in CSS and React</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Mon, 09 Nov 2026 14:55:29 +0000</pubDate>
      <link>https://dev.to/watershow/how-to-handle-prefers-reduced-motion-in-css-and-react-3lj1</link>
      <guid>https://dev.to/watershow/how-to-handle-prefers-reduced-motion-in-css-and-react-3lj1</guid>
      <description>&lt;p&gt;I recently deployed a new homepage and a redesigned blog for a project called AppData. The homepage now features a "How it works" section, a work feed integrating Apify actors, and a services block with a toggle. The blog articles and the &lt;code&gt;/tools&lt;/code&gt; pages received animated headers, text that fades in, and interactive CTA blocks. &lt;/p&gt;

&lt;p&gt;I updated the site metadata and OG images for the blog articles. I excluded the old &lt;code&gt;/build&lt;/code&gt; path from the sitemap since it now redirects to the founders section on the homepage, maintaining its anchor links. Part of the final launch checklist was making sure these new animations respected the operating system's reduced motion setting.&lt;/p&gt;

&lt;p&gt;Heavy animations can cause discomfort. Operating systems have an accessibility setting to tone down movement, which browsers expose through a CSS media query. Since I had animations in plain CSS, Tailwind classes, and React state, I needed different approaches to handle it across the project.&lt;/p&gt;

&lt;p&gt;First, I checked the animations relying on standard CSS. The blog layout has transitions that slide elements onto the screen. To disable them for users who prefer less movement, I wrapped the animation rules in a media query.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight css"&gt;&lt;code&gt;&lt;span class="k"&gt;@media&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;prefers-reduced-motion&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;reduce&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="nl"&gt;animation-duration&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="m"&gt;0.01ms&lt;/span&gt; &lt;span class="cp"&gt;!important&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
    &lt;span class="nl"&gt;animation-iteration-count&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="m"&gt;1&lt;/span&gt; &lt;span class="cp"&gt;!important&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
    &lt;span class="nl"&gt;transition-duration&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="m"&gt;0.01ms&lt;/span&gt; &lt;span class="cp"&gt;!important&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
    &lt;span class="nl"&gt;scroll-behavior&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nb"&gt;auto&lt;/span&gt; &lt;span class="cp"&gt;!important&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This snippet targets all elements and removes the duration from transitions and animations. It keeps the final state of the animation intact so the layout does not break. It also forces standard scrolling instead of smooth scrolling.&lt;/p&gt;

&lt;p&gt;For the CTA cards, the services toggle, and the FAQ section, I used Tailwind CSS. Tailwind has built-in modifiers for this media query. Instead of writing custom CSS, I prefixed the transition utility classes with the reduced motion variant.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight html"&gt;&lt;code&gt;&lt;span class="nt"&gt;&amp;lt;div&lt;/span&gt; &lt;span class="na"&gt;class=&lt;/span&gt;&lt;span class="s"&gt;"transition-transform hover:scale-105 motion-reduce:transition-none motion-reduce:hover:scale-100"&lt;/span&gt;&lt;span class="nt"&gt;&amp;gt;&lt;/span&gt;
  Keep reading
&lt;span class="nt"&gt;&amp;lt;/div&amp;gt;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This disables the scale effect if the user has requested reduced motion. I went through the homepage components and applied these classes anywhere an element moved or scaled on hover.&lt;/p&gt;

&lt;p&gt;The animated headers and text fade-ins on the blog pages rely on React to calculate timing and sequence. CSS alone cannot stop the JavaScript timers from running, which could cause layout shifts or delayed rendering. I needed to read the user's preference directly inside the React components.&lt;/p&gt;

&lt;p&gt;I wrote a custom hook that checks the media query using JavaScript.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight javascript"&gt;&lt;code&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="nx"&gt;useState&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nx"&gt;useEffect&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;react&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

&lt;span class="k"&gt;export&lt;/span&gt; &lt;span class="kd"&gt;function&lt;/span&gt; &lt;span class="nf"&gt;useReducedMotion&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="nx"&gt;matches&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nx"&gt;setMatches&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nf"&gt;useState&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="kc"&gt;false&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;

  &lt;span class="nf"&gt;useEffect&lt;/span&gt;&lt;span class="p"&gt;(()&lt;/span&gt; &lt;span class="o"&gt;=&amp;gt;&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="nx"&gt;mediaQuery&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nb"&gt;window&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;matchMedia&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;(prefers-reduced-motion: reduce)&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
    &lt;span class="nf"&gt;setMatches&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;mediaQuery&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;matches&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;

    &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="nx"&gt;handleChange&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;event&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="o"&gt;=&amp;gt;&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
      &lt;span class="nf"&gt;setMatches&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;event&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;matches&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
    &lt;span class="p"&gt;};&lt;/span&gt;

    &lt;span class="nx"&gt;mediaQuery&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;addEventListener&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;change&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nx"&gt;handleChange&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
    &lt;span class="k"&gt;return &lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt; &lt;span class="o"&gt;=&amp;gt;&lt;/span&gt; &lt;span class="nx"&gt;mediaQuery&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;removeEventListener&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="s1"&gt;change&lt;/span&gt;&lt;span class="dl"&gt;'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nx"&gt;handleChange&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
  &lt;span class="p"&gt;},&lt;/span&gt; &lt;span class="p"&gt;[]);&lt;/span&gt;

  &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="nx"&gt;matches&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Inside the animated header component, I called the hook. If it returned true, I skipped the animation sequence and rendered the text in its final visible state.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight javascript"&gt;&lt;code&gt;&lt;span class="kd"&gt;function&lt;/span&gt; &lt;span class="nf"&gt;AnimatedHeader&lt;/span&gt;&lt;span class="p"&gt;({&lt;/span&gt; &lt;span class="nx"&gt;text&lt;/span&gt; &lt;span class="p"&gt;})&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="nx"&gt;prefersReducedMotion&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nf"&gt;useReducedMotion&lt;/span&gt;&lt;span class="p"&gt;();&lt;/span&gt;

  &lt;span class="k"&gt;if &lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;prefersReducedMotion&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="o"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nx"&gt;h1&lt;/span&gt;&lt;span class="o"&gt;&amp;gt;&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="nx"&gt;text&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="o"&gt;&amp;lt;&lt;/span&gt;&lt;span class="sr"&gt;/h1&amp;gt;&lt;/span&gt;&lt;span class="err"&gt;;
&lt;/span&gt;  &lt;span class="p"&gt;}&lt;/span&gt;

  &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="o"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nx"&gt;ComplexAnimation&lt;/span&gt;&lt;span class="o"&gt;&amp;gt;&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="nx"&gt;text&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="o"&gt;&amp;lt;&lt;/span&gt;&lt;span class="sr"&gt;/ComplexAnimation&amp;gt;&lt;/span&gt;&lt;span class="err"&gt;;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Browsers allow you to simulate the preference. In Chrome, open the developer tools, press Control+Shift+P, and type "Show Rendering". In the &lt;strong&gt;Rendering&lt;/strong&gt; tab, there is a dropdown to emulate the CSS media feature &lt;code&gt;prefers-reduced-motion&lt;/code&gt;. This made checking the pages fast across different display modes.&lt;/p&gt;

&lt;p&gt;I verified there was no horizontal scroll introduced by the final animation states. All updated pages display correctly in the reduced motion mode.&lt;/p&gt;

&lt;h2&gt;
  
  
  What's next
&lt;/h2&gt;

&lt;p&gt;I need to audit the older pages on the site to ensure no legacy animations slip through the new CSS rules. I also plan to configure the testing pipeline to force the reduced motion flag in a headless browser to catch visual regressions automatically.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  How do you handle reduced motion in Tailwind CSS?
&lt;/h3&gt;

&lt;p&gt;You can use the &lt;code&gt;motion-reduce:&lt;/code&gt; prefix on your utility classes. This allows you to remove transitions or animations for users who prefer reduced motion.&lt;/p&gt;

&lt;h3&gt;
  
  
  Can you read reduced motion preferences in React?
&lt;/h3&gt;

&lt;p&gt;Yes, you can read the preference in React by using &lt;code&gt;window.matchMedia&lt;/code&gt; inside a custom hook. This lets you skip JavaScript animation sequences and render the final state immediately.&lt;/p&gt;

&lt;h3&gt;
  
  
  How do you test reduced motion in the browser?
&lt;/h3&gt;

&lt;p&gt;You can simulate the preference in your browser's developer tools. In Chrome, open the developer tools, find the &lt;strong&gt;Rendering&lt;/strong&gt; tab, and select the option to emulate the &lt;code&gt;prefers-reduced-motion&lt;/code&gt; media feature.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/handle-prefers-reduced-motion-css-react" rel="noopener noreferrer"&gt;watershowdigital.com/blog/handle-prefers-reduced-motion-css-react&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>css</category>
      <category>react</category>
      <category>a11y</category>
    </item>
    <item>
      <title>Send email alerts for overdue dates in Google Sheets via Apps Script</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Sun, 08 Nov 2026 12:26:37 +0000</pubDate>
      <link>https://dev.to/watershow/send-email-alerts-for-overdue-dates-in-google-sheets-via-apps-script-131e</link>
      <guid>https://dev.to/watershow/send-email-alerts-for-overdue-dates-in-google-sheets-via-apps-script-131e</guid>
      <description>&lt;p&gt;You track project deadlines, unpaid invoices, or renewals in a Google Sheet. Eventually, a date slips by because you forgot to open the file and look at it.&lt;/p&gt;

&lt;p&gt;Formulas alone cannot send emails or notify you outside the spreadsheet. Google Sheets includes a built-in tool called Apps Script that runs JavaScript in the background. You can write a small script that reads your rows, finds the overdue items, sends you an email, and marks them as notified.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Structuring your spreadsheet
&lt;/h2&gt;

&lt;p&gt;Your script needs predictable columns to read. If your columns move around, the script will read the wrong data and either crash or send incorrect emails. &lt;/p&gt;

&lt;p&gt;We will use a simple layout. Put your task name in column A. Put the deadline date in column B. Leave column C empty for the status. Put headers in row 1. Give the sheet tab a clear name like "Tasks".&lt;/p&gt;

&lt;p&gt;If you do not track what was already sent, the script will email you about the exact same overdue row every day. The script writes a note in this column after it sends the email, and ignores rows that already have that note.&lt;/p&gt;

&lt;p&gt;Select column B and make sure the data is formatted as an actual date. If you typed dates in a way that Google Sheets thinks is text, the script will not be able to do math with them. &lt;/p&gt;

&lt;h2&gt;
  
  
  2. Writing the Apps Script
&lt;/h2&gt;

&lt;p&gt;Click &lt;strong&gt;Extensions&lt;/strong&gt; in the top menu, then select &lt;strong&gt;Apps Script&lt;/strong&gt;. This opens a new tab with a code editor. Delete the placeholder code inside the editor and paste the script below.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight javascript"&gt;&lt;code&gt;&lt;span class="kd"&gt;function&lt;/span&gt; &lt;span class="nf"&gt;checkOverdueDates&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="nx"&gt;sheetName&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Tasks&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="nx"&gt;sheet&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nx"&gt;SpreadsheetApp&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;getActiveSpreadsheet&lt;/span&gt;&lt;span class="p"&gt;().&lt;/span&gt;&lt;span class="nf"&gt;getSheetByName&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;sheetName&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
  &lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="nx"&gt;data&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nx"&gt;sheet&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;getDataRange&lt;/span&gt;&lt;span class="p"&gt;().&lt;/span&gt;&lt;span class="nf"&gt;getValues&lt;/span&gt;&lt;span class="p"&gt;();&lt;/span&gt;
  &lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="nx"&gt;today&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;new&lt;/span&gt; &lt;span class="nc"&gt;Date&lt;/span&gt;&lt;span class="p"&gt;();&lt;/span&gt;
  &lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="nx"&gt;emailAddress&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;you@example.com&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

  &lt;span class="nx"&gt;today&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;setHours&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;

  &lt;span class="k"&gt;for &lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="nx"&gt;i&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt; &lt;span class="nx"&gt;i&lt;/span&gt; &lt;span class="o"&gt;&amp;lt;&lt;/span&gt; &lt;span class="nx"&gt;data&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nx"&gt;length&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt; &lt;span class="nx"&gt;i&lt;/span&gt;&lt;span class="o"&gt;++&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="nx"&gt;taskName&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nx"&gt;data&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="nx"&gt;i&lt;/span&gt;&lt;span class="p"&gt;][&lt;/span&gt;&lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;];&lt;/span&gt;
    &lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="nx"&gt;deadline&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;new&lt;/span&gt; &lt;span class="nc"&gt;Date&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;data&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="nx"&gt;i&lt;/span&gt;&lt;span class="p"&gt;][&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;]);&lt;/span&gt;
    &lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="nx"&gt;status&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nx"&gt;data&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="nx"&gt;i&lt;/span&gt;&lt;span class="p"&gt;][&lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;];&lt;/span&gt;

    &lt;span class="k"&gt;if &lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;deadline&lt;/span&gt; &lt;span class="k"&gt;instanceof&lt;/span&gt; &lt;span class="nb"&gt;Date&lt;/span&gt; &lt;span class="o"&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class="o"&gt;!&lt;/span&gt;&lt;span class="nf"&gt;isNaN&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;deadline&lt;/span&gt;&lt;span class="p"&gt;))&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
      &lt;span class="nx"&gt;deadline&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;setHours&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;

      &lt;span class="k"&gt;if &lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;deadline&lt;/span&gt; &lt;span class="o"&gt;&amp;lt;&lt;/span&gt; &lt;span class="nx"&gt;today&lt;/span&gt; &lt;span class="o"&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class="nx"&gt;status&lt;/span&gt; &lt;span class="o"&gt;!==&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Alert Sent&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
        &lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="nx"&gt;subject&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Overdue: &lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt; &lt;span class="o"&gt;+&lt;/span&gt; &lt;span class="nx"&gt;taskName&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
        &lt;span class="kd"&gt;var&lt;/span&gt; &lt;span class="nx"&gt;message&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;The task '&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt; &lt;span class="o"&gt;+&lt;/span&gt; &lt;span class="nx"&gt;taskName&lt;/span&gt; &lt;span class="o"&gt;+&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;' was due on &lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt; &lt;span class="o"&gt;+&lt;/span&gt; &lt;span class="nx"&gt;deadline&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;toDateString&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt; &lt;span class="o"&gt;+&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;.&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

        &lt;span class="nx"&gt;MailApp&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;sendEmail&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;emailAddress&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nx"&gt;subject&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nx"&gt;message&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;

        &lt;span class="nx"&gt;sheet&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;getRange&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nx"&gt;i&lt;/span&gt; &lt;span class="o"&gt;+&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;3&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;&lt;span class="nf"&gt;setValue&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Alert Sent&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;
      &lt;span class="p"&gt;}&lt;/span&gt;
    &lt;span class="p"&gt;}&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Update the email address in the code to your actual email address. Update the sheet name variable if you named your tab something other than "Tasks".&lt;/p&gt;

&lt;p&gt;The script loads your entire sheet into memory at once using the data range values. It creates a date object for today and forces the time to midnight. This ensures we only compare calendar days, avoiding situations where a task due today at 5 PM is flagged as overdue at 8 AM.&lt;/p&gt;

&lt;p&gt;It then loops through your data. Arrays in JavaScript start counting at zero. The loop starts at 1 to skip your header row. Inside the loop, &lt;code&gt;data[i][0]&lt;/code&gt; is column A, &lt;code&gt;data[i][1]&lt;/code&gt; is column B, and &lt;code&gt;data[i][2]&lt;/code&gt; is column C. &lt;/p&gt;

&lt;p&gt;If the date is valid, it compares it to today. If the deadline is older than today and the status does not say "Alert Sent", it uses the MailApp tool to send an email. Finally, it targets the exact cell in column C using &lt;code&gt;getRange&lt;/code&gt; and writes the status.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. Testing and authorizing the script
&lt;/h2&gt;

&lt;p&gt;Before relying on the automation, test it manually. Go back to your spreadsheet. Change one of the dates in column B to yesterday. Leave column C completely empty.&lt;/p&gt;

&lt;p&gt;Go back to the script editor. Select your function from the dropdown at the top and click &lt;strong&gt;Run&lt;/strong&gt;. &lt;/p&gt;

&lt;p&gt;Google will show a warning popup requiring you to authorize the script to read your spreadsheets and send emails on your behalf. Click &lt;strong&gt;Review permissions&lt;/strong&gt;. Choose your Google account. Google will show a warning that the app is unverified. Click &lt;strong&gt;Advanced&lt;/strong&gt;, then click the link at the bottom to proceed to your script. Click &lt;strong&gt;Allow&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;Check your email inbox. You will see a new email with the task name and the due date. Column C in that spreadsheet row will now say "Alert Sent". Run the script one more time manually. You will not get a second email because the script sees the status and skips the row.&lt;/p&gt;

&lt;h2&gt;
  
  
  4. Scheduling the daily automation
&lt;/h2&gt;

&lt;p&gt;You need Google's servers to run this function automatically every morning by setting up a trigger.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;In the left sidebar of the script editor, click the clock icon labeled &lt;strong&gt;Triggers&lt;/strong&gt;.&lt;/li&gt;
&lt;li&gt;Click the button to add a new trigger at the bottom right.&lt;/li&gt;
&lt;li&gt;Choose your script function name from the first dropdown.&lt;/li&gt;
&lt;li&gt;Set the event source to time-driven.&lt;/li&gt;
&lt;li&gt;Set the type of time based trigger to day timer.&lt;/li&gt;
&lt;li&gt;Pick a time slot for the emails, like 8 AM to 9 AM, and save.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Google will now wake up your script every day during that window. It will scan the entire sheet and email you only about tasks that fell behind schedule since yesterday.&lt;/p&gt;

&lt;h2&gt;
  
  
  Still stuck?
&lt;/h2&gt;

&lt;p&gt;Simple scripts work well for flat data, but things get complicated when you need to fetch data from APIs, parse incoming emails, or sync your sheet with external databases. If your spreadsheet automation needs have outgrown a basic script, &lt;a href="https://dev.to/build"&gt;this is the kind of fix I do&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  Why does the script email me multiple times for the same row?
&lt;/h3&gt;

&lt;p&gt;The script is likely failing to read the status column correctly, or the column index in the code does not match your actual spreadsheet layout. Ensure the script writes "Alert Sent" to the correct column and checks that exact spelling on the next run.&lt;/p&gt;

&lt;h3&gt;
  
  
  Can I send emails to different people based on the row data?
&lt;/h3&gt;

&lt;p&gt;Yes, if you put email addresses in another column, you can read that column in the script loop. You assign that value to a variable and pass it to the MailApp function instead of using a hardcoded email address.&lt;/p&gt;

&lt;h3&gt;
  
  
  Why does the date comparison fail and ignore my rows?
&lt;/h3&gt;

&lt;p&gt;The script expects a real date format in your spreadsheet cells so it can create a valid JavaScript date object. If your dates are stored as plain text, the math will fail and the script will skip the row.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/google-sheets-overdue-email-alerts" rel="noopener noreferrer"&gt;watershowdigital.com/blog/google-sheets-overdue-email-alerts&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>googlesheets</category>
      <category>appsscript</category>
      <category>automation</category>
    </item>
    <item>
      <title>What is Model Context Protocol (MCP) and how to use it</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Sat, 07 Nov 2026 13:26:21 +0000</pubDate>
      <link>https://dev.to/watershow/what-is-model-context-protocol-mcp-and-how-to-use-it-3kn4</link>
      <guid>https://dev.to/watershow/what-is-model-context-protocol-mcp-and-how-to-use-it-3kn4</guid>
      <description>&lt;p&gt;AI assistants previously required custom integrations for every tool or data source you wanted them to access. If you wanted an assistant to interact with a specific software environment, you had to maintain separate connection logic for each host application. &lt;/p&gt;

&lt;p&gt;The Model Context Protocol defines a single open standard for connecting AI apps to external tools. A server declares what it can do, the host application shows those capabilities to the model, and the model requests actions when needed. You build the server once, and any compatible assistant can use it.&lt;/p&gt;

&lt;h2&gt;
  
  
  How the protocol works
&lt;/h2&gt;

&lt;p&gt;The architecture relies on three distinct parts. The host is the AI application you use, like Claude Desktop or Cursor. The server is a program that exposes specific tools, data or prompts. The model decides what to use based on the user request. &lt;/p&gt;

&lt;p&gt;The model never talks to a server directly. According to &lt;a href="https://mcp-explained.com/" rel="noopener noreferrer"&gt;MCP Explained&lt;/a&gt;, the host acts as the middleman. When the model needs something, the host application calls the server and hands the result back to the model.&lt;/p&gt;

&lt;p&gt;Communication does not use standard REST APIs. Instead, the protocol relies on JSON-RPC. This JSON-RPC envelope travels over stdin and stdout, or through HTTP endpoints. The specification defines the methods, capability negotiation, transports, and authentication that go inside this envelope. Servers also have the ability to send messages back to the host.&lt;/p&gt;

&lt;h2&gt;
  
  
  Real-world example: Roblox Studio
&lt;/h2&gt;

&lt;p&gt;The &lt;a href="https://github.com/HerdBuilderEstimate/roblox-studio-mcp" rel="noopener noreferrer"&gt;HerdBuilderEstimate/roblox-studio-mcp&lt;/a&gt; project is an open-source server that bridges Roblox Studio and AI coding assistants. &lt;/p&gt;

&lt;p&gt;It is a Node.js and TypeScript server. It communicates via WebSockets and standard input/output. A Lua plugin handles the operations inside the Roblox Studio API. &lt;/p&gt;

&lt;p&gt;The server allows language models to understand the architecture of a game, generate Lua scripts, and automate developer tasks. Because it follows the standard protocol, it is compatible with Claude Desktop, Cursor, Cline, and ChatGPT through adapters.&lt;/p&gt;

&lt;p&gt;The server exposes specific tools to the AI agent. The model can call &lt;code&gt;get_object_tree&lt;/code&gt; to return the full hierarchy of the current place. It can use &lt;code&gt;get_instance&lt;/code&gt; to fetch details of a specific object by its path. For editing, the model can trigger &lt;code&gt;create_script&lt;/code&gt; to make a new Lua script or &lt;code&gt;update_script&lt;/code&gt; to replace the source code of an existing script. &lt;/p&gt;

&lt;p&gt;The model can also inspect and modify properties using &lt;code&gt;get_properties&lt;/code&gt; and &lt;code&gt;set_property&lt;/code&gt;. The tools &lt;code&gt;run_playtest&lt;/code&gt; and &lt;code&gt;stop_playtest&lt;/code&gt; allow the agent to start and stop playtest sessions.&lt;/p&gt;

&lt;h2&gt;
  
  
  Connecting the server to an AI host
&lt;/h2&gt;

&lt;p&gt;To use an existing server, add it to the configuration file of your AI assistant. &lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Open the configuration file for your client, such as &lt;code&gt;claude_desktop_config.json&lt;/code&gt;.&lt;/li&gt;
&lt;li&gt;Add the server details inside the &lt;code&gt;mcpServers&lt;/code&gt; object.&lt;/li&gt;
&lt;li&gt;Restart your AI assistant so it reads the new configuration.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Here is the exact configuration block needed to connect the Roblox Studio server:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"mcpServers"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="nl"&gt;"roblox-studio"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"command"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"npx"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"args"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"-y"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"roblox-studio-mcp"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Once restarted, the host discovers the tools and the server automatically finds open Studio sessions.&lt;/p&gt;

&lt;p&gt;You can adjust the server settings using environment variables. The variable &lt;code&gt;RBX_MCP_PORT&lt;/code&gt; changes the WebSocket port from the default 44755. You can control logging with &lt;code&gt;RBX_MCP_LOG_LEVEL&lt;/code&gt; and change the request timeout length with &lt;code&gt;RBX_MCP_TIMEOUT&lt;/code&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  The catch
&lt;/h2&gt;

&lt;p&gt;The server implementation defines the security boundaries, not the protocol itself. If the server exposes destructive tools, the AI host can use them. &lt;/p&gt;

&lt;p&gt;For the Roblox Studio integration, you must have edit access to the place for the tools to work. The server includes a &lt;code&gt;delete_instance&lt;/code&gt; tool that removes objects from your project. To prevent the AI from making unwanted changes, you run the server in safe mode. Setting the environment variable &lt;code&gt;RBX_MCP_SAFE_MODE&lt;/code&gt; to true disables destructive actions and prevents object deletion. The server sandboxes all operations within the Studio plugin, meaning it cannot execute untrusted code outside of that environment or manipulate memory directly.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  What is the Model Context Protocol?
&lt;/h3&gt;

&lt;p&gt;It is an open standard that uses JSON-RPC over stdin/stdout or HTTP to connect AI applications to external data and tools. A server exposes tools, the host application shows them to the model, and the host calls the server when the model requests an action.&lt;/p&gt;

&lt;h3&gt;
  
  
  Does the AI model talk directly to my tools?
&lt;/h3&gt;

&lt;p&gt;No. The model never talks directly to a server. The host application acts as a middleman, calling the server and passing the results back to the model.&lt;/p&gt;

&lt;h3&gt;
  
  
  How do I stop an AI agent from breaking my Roblox game?
&lt;/h3&gt;

&lt;p&gt;You can set the environment variable &lt;code&gt;RBX_MCP_SAFE_MODE&lt;/code&gt; to true. This enables a read-only mode that disables destructive actions like the tool that deletes instances.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/what-is-model-context-protocol-mcp" rel="noopener noreferrer"&gt;watershowdigital.com/blog/what-is-model-context-protocol-mcp&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>ai</category>
      <category>mcp</category>
      <category>cursor</category>
      <category>architecture</category>
    </item>
    <item>
      <title>How to bulk update missing SKUs for existing Shopify products</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Fri, 06 Nov 2026 17:45:26 +0000</pubDate>
      <link>https://dev.to/watershow/how-to-bulk-update-missing-skus-for-existing-shopify-products-1lnj</link>
      <guid>https://dev.to/watershow/how-to-bulk-update-missing-skus-for-existing-shopify-products-1lnj</guid>
      <description>&lt;p&gt;You connect a new fulfillment tool or inventory tracker to your Shopify store and it immediately throws errors. Some orders fail to sync, or stock levels stay stuck at zero even after you receive a new shipment. &lt;/p&gt;

&lt;p&gt;The system flags that your variants are missing SKUs. This happens when you migrate from another platform, use a dropshipping integration, or create products manually. &lt;/p&gt;

&lt;p&gt;A SKU is the reliable way for external software to identify which physical item needs to be picked off a shelf. Product titles and handle names change, but SKUs remain static. You can fix missing identifiers manually with a spreadsheet or write a script to automate the backfilling process.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Finding empty SKUs via CSV export
&lt;/h2&gt;

&lt;p&gt;Shopify lets you pull your catalog, modify specific columns, and push updates back to your live store.&lt;/p&gt;

&lt;p&gt;Open your Shopify admin and navigate to &lt;strong&gt;Products&lt;/strong&gt;.&lt;br&gt;
Click &lt;strong&gt;Export&lt;/strong&gt;.&lt;br&gt;
Select the option to export all products and choose the CSV format.&lt;br&gt;
Open the downloaded file in Microsoft Excel or Google Sheets.&lt;/p&gt;

&lt;p&gt;Look for the column titled &lt;strong&gt;Variant SKU&lt;/strong&gt;. This column holds the identifier for every variant. If a product has no variants, the default version gets its own row and needs a SKU. &lt;/p&gt;

&lt;p&gt;Set a filter on the &lt;strong&gt;Variant SKU&lt;/strong&gt; column to only show blank cells. This hides the products that are already set up correctly so you do not overwrite them.&lt;/p&gt;
&lt;h2&gt;
  
  
  2. Generating new SKUs systematically
&lt;/h2&gt;

&lt;p&gt;Generating SKUs with a formula prevents typos. A standard format combines a brand prefix, a category code, and a unique number.&lt;/p&gt;

&lt;p&gt;In the first empty cell of the SKU column, write a spreadsheet formula to generate an identifier based on the current row number:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;="BRAND-TSHIRT-" &amp;amp; TEXT(ROW(), "0000")
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This formula takes a text prefix and attaches the row number, padded with leading zeros. If you put this in row 45, the result is BRAND-TSHIRT-0045. &lt;/p&gt;

&lt;p&gt;Copy this formula and paste it down the entire column for all filtered blank rows. Once the cells are filled, convert the formulas to plain text by highlighting the cells, copying them, and pasting them as values over the exact same cells.&lt;/p&gt;

&lt;p&gt;Save your spreadsheet as a CSV file. Go back to the &lt;strong&gt;Products&lt;/strong&gt; page in Shopify and click &lt;strong&gt;Import&lt;/strong&gt;. Upload your saved file. Check the box to &lt;strong&gt;Overwrite any current products that have the same handle&lt;/strong&gt;. This updates your existing database instead of creating duplicate items.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. Automating backfills with the GraphQL API
&lt;/h2&gt;

&lt;p&gt;Spreadsheets work well for a one-time cleanup. If your store imports new items from external supplier feeds that drop SKUs, you will repeat the CSV process every week. &lt;/p&gt;

&lt;p&gt;You can build an automation to handle this in the background. A script can run on a daily schedule, ask the Shopify GraphQL API for variants with empty SKUs, and update them.&lt;/p&gt;

&lt;p&gt;Create a custom app in your project settings to get an access token. The script uses that token to query the Admin API. &lt;/p&gt;

&lt;p&gt;Here is a Python example that finds variants missing a SKU:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;requests&lt;/span&gt;

&lt;span class="n"&gt;SHOPIFY_DOMAIN&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;your-store.myshopify.com&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;
&lt;span class="n"&gt;ACCESS_TOKEN&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;shpat_your_access_token_here&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;

&lt;span class="n"&gt;headers&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;X-Shopify-Access-Token&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;ACCESS_TOKEN&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Content-Type&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;application/json&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="n"&gt;query&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="sh"&gt;"""&lt;/span&gt;&lt;span class="s"&gt;
{
  products(first: 50, query: &lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;sku:&lt;/span&gt;&lt;span class="sh"&gt;''"&lt;/span&gt;&lt;span class="s"&gt;) {
    edges {
      node {
        id
        title
        variants(first: 10) {
          edges {
            node {
              id
              sku
              title
            }
          }
        }
      }
    }
  }
}
&lt;/span&gt;&lt;span class="sh"&gt;"""&lt;/span&gt;

&lt;span class="n"&gt;response&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;requests&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;post&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="sa"&gt;f&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;https://&lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;SHOPIFY_DOMAIN&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt;/admin/api/2024-01/graphql.json&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;headers&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="n"&gt;headers&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;json&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;query&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;query&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;)&lt;/span&gt;

&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;response&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;json&lt;/span&gt;&lt;span class="p"&gt;())&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This query asks for products where a variant has an empty SKU. The script receives a JSON response containing the internal IDs for those variants. &lt;/p&gt;

&lt;p&gt;Once you have the IDs, the script can generate a new SKU string using your custom logic. It then sends a mutation request back to the Shopify API to update the variant:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="n"&gt;mutation&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="sh"&gt;"""&lt;/span&gt;&lt;span class="s"&gt;
mutation productVariantUpdate($input: ProductVariantInput!) {
  productVariantUpdate(input: $input) {
    productVariant {
      id
      sku
    }
    userErrors {
      field
      message
    }
  }
}
&lt;/span&gt;&lt;span class="sh"&gt;"""&lt;/span&gt;

&lt;span class="n"&gt;variables&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;input&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
        &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;id&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;gid://shopify/ProductVariant/1234567890&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;sku&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;AUTO-GEN-1001&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;
    &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="n"&gt;update_response&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;requests&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;post&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="sa"&gt;f&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;https://&lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;SHOPIFY_DOMAIN&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt;/admin/api/2024-01/graphql.json&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;headers&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="n"&gt;headers&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;json&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;query&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;mutation&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;variables&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;variables&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Running a script like this on a cron job ensures that no product stays in your store without a valid SKU.&lt;/p&gt;

&lt;h2&gt;
  
  
  Still stuck?
&lt;/h2&gt;

&lt;p&gt;If products get imported so fast that weekly manual cleanups are too slow, and you need a script built to catch and update bad product data automatically, &lt;a href="https://dev.to/build"&gt;this is the kind of fix I do&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  How do I find products without SKUs in Shopify?
&lt;/h3&gt;

&lt;p&gt;Export your product catalog to a CSV file from the Shopify admin. Once opened in a spreadsheet, filter the SKU column to only show blank cells. This isolates the variants that need to be updated.&lt;/p&gt;

&lt;h3&gt;
  
  
  Can I generate SKUs automatically in Excel?
&lt;/h3&gt;

&lt;p&gt;Yes, you can write a formula using text prefixes and the row number. An example is joining the text "BRAND-" with the ROW() function to create a unique identifier for each empty cell.&lt;/p&gt;

&lt;h3&gt;
  
  
  How do I stop suppliers from importing products without SKUs?
&lt;/h3&gt;

&lt;p&gt;You cannot always control external feeds, but you can automate the cleanup. A custom script using the Shopify GraphQL API can periodically scan for empty SKUs and update them based on your rules.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/shopify-bulk-update-missing-skus" rel="noopener noreferrer"&gt;watershowdigital.com/blog/shopify-bulk-update-missing-skus&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>shopify</category>
      <category>automation</category>
      <category>ecommerce</category>
    </item>
    <item>
      <title>Free API credits for ChatGPT and Claude users, plus new privacy risks</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Wed, 04 Nov 2026 14:43:51 +0000</pubDate>
      <link>https://dev.to/watershow/free-api-credits-for-chatgpt-and-claude-users-plus-new-privacy-risks-2l6c</link>
      <guid>https://dev.to/watershow/free-api-credits-for-chatgpt-and-claude-users-plus-new-privacy-risks-2l6c</guid>
      <description>&lt;p&gt;AI providers are now bundling free API credits with their premium chat subscriptions. At the same time, two major developer tools silently changed privacy settings that expose your local code and API traffic.&lt;/p&gt;

&lt;p&gt;You can build scrapers, bots, and single page apps using premium models without paying extra. You also need to check your local configuration to stop your client code from being sent to training servers or third party APIs without your permission.&lt;/p&gt;

&lt;h2&gt;
  
  
  Claude API credits
&lt;/h2&gt;

&lt;p&gt;Anthropic now gives monthly API credits to users on specific paid plans. If you pay for the Max or Ultra tier, or if you use a Team plan, you get a separate API balance to use in your own apps. Max users get 100 dollars. Ultra users get 200 dollars. Team plans receive 20 dollars or 100 dollars per seat, capped at a maximum of 500 dollars. &lt;/p&gt;

&lt;p&gt;To get the credits, you must have an active subscription in good standing for seven days. You do not need to add a credit card to the Claude Platform. According to &lt;a href="https://support.claude.com/en/articles/17154008-monthly-api-credits-for-max-ultra-and-team-plans" rel="noopener noreferrer"&gt;Monthly API credits for Max, Ultra, and Team plans | Claude Help Center&lt;/a&gt;, you claim the credits by linking an organization:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Go to your account or organization billing settings.&lt;/li&gt;
&lt;li&gt;Locate the API credits section.&lt;/li&gt;
&lt;li&gt;Click the option to link an organization.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;These credits do not roll over to the next month. They expire at the end of each billing cycle. You cannot use them for interactive Claude Code sessions in your terminal or IDE. They are strictly for the API, Playground, and Managed Agents.&lt;/p&gt;

&lt;h2&gt;
  
  
  ChatGPT API credits
&lt;/h2&gt;

&lt;p&gt;OpenAI offers a similar benefit for eligible ChatGPT Pro and Business subscribers. The API credits allow you to build custom integrations without separate billing.&lt;/p&gt;

&lt;p&gt;Pro subscribers receive 100, 200, or 500 dollars based on their specific tier. Business plans get 20 dollars per Standard seat or 100 dollars per Premium seat. This pool is also capped at 500 dollars per workspace. The official &lt;a href="https://developers.openai.com/api/docs/guides/chatgpt-api-credits" rel="noopener noreferrer"&gt;API credits for ChatGPT subscribers - OpenAI Developers&lt;/a&gt; page notes that you must activate the benefit by linking your subscription to an API organization you own.&lt;/p&gt;

&lt;p&gt;You can claim these credits by visiting the ChatGPT billing page at &lt;a href="https://chatgpt.com/settings/billing" rel="noopener noreferrer"&gt;https://chatgpt.com/settings/billing&lt;/a&gt;. Your first grant is prorated based on the time remaining in your paid billing period. The credits expire at the end of the subscription billing cycle and do not roll over. &lt;/p&gt;

&lt;p&gt;Some users report problems claiming their balance. According to &lt;a href="https://community.openai.com/t/claim-up-to-500-in-api-credits-using-your-chatgpt-pro-or-business-subscription/1410579" rel="noopener noreferrer"&gt;Claim up to 500$ in API credits using your ChatGPT Pro or Business ...&lt;/a&gt;, people who purchased their subscription through the Apple App Store or Google Play Store cannot see the claim option. Others found that their credits disappeared after their monthly auto renewal triggered.&lt;/p&gt;

&lt;h2&gt;
  
  
  Using credits in Lovable and Next.js apps
&lt;/h2&gt;

&lt;p&gt;When you use these new API credits to build apps, you must configure your environment variables correctly. &lt;/p&gt;

&lt;p&gt;Lovable and Bolt apps are Vite and React single page apps that use Supabase for the backend. They do not use Next.js unless you explicitly add it. In a Vite app, your client environment variables must start with VITE_. If you put your OpenAI or Anthropic API key in a VITE_ variable, it will be exposed to every visitor. You should call the AI APIs from a secure backend environment like a Supabase Edge Function instead.&lt;/p&gt;

&lt;p&gt;If you build with Next.js, client environment variables start with NEXT_PUBLIC_. These variables are inlined at build time. If you change a NEXT_PUBLIC_ variable, you must trigger a redeploy for the change to take effect in the browser.&lt;/p&gt;

&lt;p&gt;For authentication, Supabase OAuth requires correct URL settings. When users sign in with Google or GitHub, the provider sends the callback to a specific address:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;https://&amp;lt;project-ref&amp;gt;.supabase.co/auth/v1/callback
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;You must configure your own domains in the Supabase dashboard. Navigate to &lt;strong&gt;Authentication&lt;/strong&gt; then find &lt;strong&gt;URL Configuration&lt;/strong&gt; to set your &lt;strong&gt;Site URL&lt;/strong&gt; and &lt;strong&gt;Redirect URLs&lt;/strong&gt;. The Supabase service_role key must never reach the browser. Keep it strictly on the server.&lt;/p&gt;

&lt;h2&gt;
  
  
  The catch
&lt;/h2&gt;

&lt;p&gt;Recent updates have introduced privacy risks for developers using AI tools. &lt;/p&gt;

&lt;p&gt;OpenAI changed user settings without notification. According to &lt;a href="https://news.ycombinator.com/item?id=50352757" rel="noopener noreferrer"&gt;OpenAI seems to be silently re-enabling model training on Codex chats&lt;/a&gt;, developers who previously opted out of data sharing found that the setting had been silently re-enabled in Codex. If you use Codex for work, you must verify your data sharing preferences again to ensure your code is not used for model training.&lt;/p&gt;

&lt;p&gt;The Postman desktop application automatically installs AI plugins without asking for permission. The issue is documented in &lt;a href="https://github.com/postmanlabs/postman-app-support/issues/14370" rel="noopener noreferrer"&gt;Postman silently auto-installs AI plugins and attempts to share all API data&lt;/a&gt;. &lt;/p&gt;

&lt;p&gt;When you open Postman desktop version 12.33.4, the software installs plugins for Codex and Claude. It then modifies your global user configuration to trust its own startup hook.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight toml"&gt;&lt;code&gt;&lt;span class="k"&gt;[&lt;/span&gt;&lt;span class="n"&gt;marketplaces&lt;/span&gt;&lt;span class="k"&gt;.&lt;/span&gt;&lt;span class="n"&gt;postman&lt;/span&gt;&lt;span class="k"&gt;]&lt;/span&gt;
&lt;span class="n"&gt;source_type&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s"&gt;"git"&lt;/span&gt;
&lt;span class="n"&gt;source&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s"&gt;"https://github.com/postmanlabs/postman-plugin.git"&lt;/span&gt;

&lt;span class="k"&gt;[&lt;/span&gt;&lt;span class="n"&gt;plugins&lt;/span&gt;&lt;span class="k"&gt;.&lt;/span&gt;&lt;span class="s"&gt;"postman@postman"&lt;/span&gt;&lt;span class="k"&gt;]&lt;/span&gt;
&lt;span class="n"&gt;enabled&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="kc"&gt;true&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The installer explicitly attempts to approve this hook. The hook instructs the coding agent to route API engineering tasks through Postman skills. This happens automatically when the agent starts. Postman also adds a remote connection pointing to an external server.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"mcpServers"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="nl"&gt;"postman"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"command"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"node"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"args"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"..."&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"url"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://mcp.postman.com/mcp"&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This integration happens even if you just open Postman after leaving it closed for a while. It alters your global agent configurations and sets Postman as the default tool for general API work. You must manually check your agent configurations and remove the unwanted hooks if you opened Postman recently.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  How do I claim Claude API credits?
&lt;/h3&gt;

&lt;p&gt;You claim Claude API credits by going to your account billing settings and clicking the option to link an organization. You must be on an eligible Max, Ultra, or Team plan for seven days before the option appears. The credits will go to the single console organization you select.&lt;/p&gt;

&lt;h3&gt;
  
  
  Do App Store subscriptions get ChatGPT credits?
&lt;/h3&gt;

&lt;p&gt;Users who subscribed to ChatGPT Pro through the Apple App Store or Google Play Store report that the option to claim credits is missing. Some users also state that their credits disappeared after an automatic renewal. The documentation states you must wait seven days after a subscription change.&lt;/p&gt;

&lt;h3&gt;
  
  
  What does the Postman plugin do?
&lt;/h3&gt;

&lt;p&gt;The auto-installed Postman plugin alters your coding agent configuration to route API engineering tasks through Postman skills. It attempts to approve its own startup hook and adds a remote connection to a Postman server. It installs these changes automatically when you open the Postman desktop app.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/free-api-credits-chatgpt-claude-privacy" rel="noopener noreferrer"&gt;watershowdigital.com/blog/free-api-credits-chatgpt-claude-privacy&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>ai</category>
      <category>openai</category>
      <category>api</category>
      <category>privacy</category>
    </item>
    <item>
      <title>101 EU online stores checked for the EAA: 93% have accessibility gaps</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Tue, 03 Nov 2026 15:28:11 +0000</pubDate>
      <link>https://dev.to/watershow/101-eu-online-stores-checked-for-the-eaa-93-have-accessibility-gaps-103a</link>
      <guid>https://dev.to/watershow/101-eu-online-stores-checked-for-the-eaa-93-have-accessibility-gaps-103a</guid>
      <description>&lt;p&gt;The European Accessibility Act has applied to online stores since 28 June 2025. If you sell to consumers in the EU, your shop has to be usable by people who rely on screen readers, keyboards, zoom and high contrast. Only microenterprises (fewer than 10 people and no more than €2 million a year) are exempt from the rules for services.&lt;/p&gt;

&lt;p&gt;More than a year later, how are real stores doing? In November 2026 we ran the same free check that powers our &lt;a href="https://watershowdigital.com/eaa-check" rel="noopener noreferrer"&gt;EAA check tool&lt;/a&gt; on the homepages of 102 online stores in 14 EU countries: large retailers and smaller direct-to-consumer brands.&lt;/p&gt;

&lt;p&gt;Short version: 94 of the 101 stores we could test had at least one accessibility problem that an automated check can find on the homepage alone.&lt;/p&gt;

&lt;h2&gt;
  
  
  How we checked
&lt;/h2&gt;

&lt;p&gt;For every store we tested the homepage on a mobile phone profile, because that is how most people shop.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Accessibility audit.&lt;/strong&gt; Google Lighthouse through PageSpeed Insights. It runs the axe rules and gives a score from 0 to 100. One store did not load in Lighthouse, so this part covers 101 stores.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Homepage HTML.&lt;/strong&gt; We looked for a link to an accessibility statement, the page language, the shop platform and accessibility overlay widgets. 29 stores blocked automated requests, so this part covers 66 stores.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Two limits matter. Automated checks only catch part of the problems: things like a checkout you cannot finish with a keyboard need a person to test them. And a homepage is not the whole shop. So treat these numbers as a floor, not a full audit. We do not name any store in this report.&lt;/p&gt;

&lt;h2&gt;
  
  
  The headline numbers
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;94 of 101 stores (93%)&lt;/strong&gt; had at least one automated accessibility issue on the homepage.&lt;/li&gt;
&lt;li&gt;The median Lighthouse accessibility score was &lt;strong&gt;91 out of 100&lt;/strong&gt;. 45 stores scored below 90, 10 below 80. 13 stores scored a full 100.&lt;/li&gt;
&lt;li&gt;A store had &lt;strong&gt;3.4 different issue types&lt;/strong&gt; on its homepage on average.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;45 of 66 stores (68%)&lt;/strong&gt; linked an accessibility statement from the homepage. &lt;strong&gt;21 (32%)&lt;/strong&gt; did not.&lt;/li&gt;
&lt;li&gt;Only 4 of 66 stores had no automated issue and a statement link. The other 62 had one gap or both.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What fails most often
&lt;/h2&gt;

&lt;p&gt;Most of these problems live in the shop theme, so one fix repairs every page.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Links have no name (43% of stores).&lt;/strong&gt; A screen reader hears "link" with no idea where it goes. Usually icon links: cart, wishlist, social icons.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Button names don't match their visible text (40% of stores).&lt;/strong&gt; A voice-control user says "Add to bag", but the button is named something else, so nothing happens.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Text is too faint to read (37% of stores).&lt;/strong&gt; Grey text on white, prices and labels below the 4.5:1 contrast ratio.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Buttons and links are too small to tap (30% of stores).&lt;/strong&gt; Targets under 24 by 24 pixels with no space around them.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Buttons have no name (26% of stores).&lt;/strong&gt; Icon buttons (menu, search, close) with nothing for a screen reader to read.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Headings skip levels (23% of stores).&lt;/strong&gt; The page jumps from h1 to h4, so screen reader users lose the page outline.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Photos have no description (16% of stores).&lt;/strong&gt; Product images without alt text.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Zoom is blocked on phones (13% of stores).&lt;/strong&gt; The viewport tag stops people from pinching to zoom.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Platforms
&lt;/h2&gt;

&lt;p&gt;Shopify stores averaged a score of 93 (12 stores), Next.js storefronts 93 (7), and stores where we could not tell the platform 87 (43). Magento averaged 79, but we only had 3 Magento stores, so read that as a hint, not a result. The sample per country was too small to rank countries.&lt;/p&gt;

&lt;p&gt;Only 2 of 66 stores used an accessibility overlay widget. That is a good sign: an overlay adds a toolbar on top of the page, but it does not fix the code underneath, and it does not make a store compliant on its own.&lt;/p&gt;

&lt;h2&gt;
  
  
  What to do if you run an online store
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Run the free check on your own homepage and a product page: &lt;a href="https://watershowdigital.com/eaa-check" rel="noopener noreferrer"&gt;watershowdigital.com/eaa-check&lt;/a&gt;. It shows each problem in plain words with the exact element and a fix.&lt;/li&gt;
&lt;li&gt;Fix the theme-level issues first: names for icon links and buttons, contrast of text and prices, tap target size, and the zoom setting in the viewport tag.&lt;/li&gt;
&lt;li&gt;Publish an accessibility statement and link it from the footer of every page. The check page has a free generator for it.&lt;/li&gt;
&lt;li&gt;Test the parts no automated tool can see: the checkout with a keyboard only, and with a screen reader.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;If you would rather hand it over, I do an accessibility audit for €99 and fixes from €199, with a fixed quote first.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  Does the European Accessibility Act apply to my online store?
&lt;/h3&gt;

&lt;p&gt;If you sell products or services to consumers in the EU online, it most likely does. The rules for services exempt microenterprises: fewer than 10 people and no more than €2 million in annual turnover or balance sheet total.&lt;/p&gt;

&lt;h3&gt;
  
  
  Is a Lighthouse score of 100 enough to be compliant?
&lt;/h3&gt;

&lt;p&gt;No. A score of 100 means the automated checks passed. Problems like a checkout you cannot finish with a keyboard need manual testing.&lt;/p&gt;

&lt;h3&gt;
  
  
  Do accessibility overlay widgets make a store compliant?
&lt;/h3&gt;

&lt;p&gt;No. An overlay adds a toolbar on top of the page, but the problems in the code stay where they are.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/eu-stores-accessibility-report-2026" rel="noopener noreferrer"&gt;watershowdigital.com/blog/eu-stores-accessibility-report-2026&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>a11y</category>
      <category>eaa</category>
      <category>ecommerce</category>
      <category>wcag</category>
    </item>
    <item>
      <title>Fix 'RLS is disabled' warning in Supabase Security Advisor</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Tue, 03 Nov 2026 13:44:01 +0000</pubDate>
      <link>https://dev.to/watershow/fix-rls-is-disabled-warning-in-supabase-security-advisor-5bn5</link>
      <guid>https://dev.to/watershow/fix-rls-is-disabled-warning-in-supabase-security-advisor-5bn5</guid>
      <description>&lt;p&gt;You open your Supabase dashboard and see a warning. The Security Advisor tells you "RLS is disabled" for one or more tables. You might also see a yellow unlock icon next to a table name in the editor.&lt;/p&gt;

&lt;p&gt;This happens because new tables in Supabase default to having Row Level Security turned off. Your web app uses a public anon key to talk to the database. This key lives in your frontend code. In Next.js, it starts with &lt;code&gt;NEXT_PUBLIC_&lt;/code&gt;. In Vite-based tools like Lovable or Bolt, it starts with &lt;code&gt;VITE_&lt;/code&gt;. Because this key is public, anyone can find it in their browser network tab. If RLS is disabled on a table, anyone with that public key can read, edit, or delete every record in your database.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. The table was created manually without RLS
&lt;/h2&gt;

&lt;p&gt;When you create a table in the Supabase interface, there is a checkbox to enable Row Level Security. It is easy to skip this step.&lt;/p&gt;

&lt;p&gt;To confirm this is the problem, check the policies page in your project settings. If a table says RLS is disabled, this is the root cause.&lt;/p&gt;

&lt;p&gt;Fixing it requires turning the feature on and telling the database what is allowed:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Click the &lt;strong&gt;Enable RLS&lt;/strong&gt; button next to your table name.&lt;/li&gt;
&lt;li&gt;Test your web app. It will show no data, because an empty RLS configuration blocks all access.&lt;/li&gt;
&lt;li&gt;Click &lt;strong&gt;New Policy&lt;/strong&gt; and choose the option to create a policy from scratch.&lt;/li&gt;
&lt;li&gt;Select the SELECT operation.&lt;/li&gt;
&lt;li&gt;In the SQL expression box, type &lt;code&gt;true&lt;/code&gt;.&lt;/li&gt;
&lt;li&gt;Save the policy.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Now your app can read data safely. Because you only created a SELECT policy, users cannot insert or delete data.&lt;/p&gt;

&lt;h2&gt;
  
  
  2. An AI builder generated the table without security
&lt;/h2&gt;

&lt;p&gt;AI tools often write database creation scripts that skip security rules to get the app working quickly.&lt;/p&gt;

&lt;p&gt;If the table has a &lt;code&gt;user_id&lt;/code&gt; column meant to track ownership, but the Security Advisor flags it for disabled RLS, the AI left your data unprotected.&lt;/p&gt;

&lt;p&gt;You need to restrict data access so users only see and edit their own rows:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Go to the policies settings.&lt;/li&gt;
&lt;li&gt;Click &lt;strong&gt;New Policy&lt;/strong&gt; for your table and start from scratch.&lt;/li&gt;
&lt;li&gt;Select the SELECT operation.&lt;/li&gt;
&lt;li&gt;In the expression box, type &lt;code&gt;auth.uid() = user_id&lt;/code&gt;.&lt;/li&gt;
&lt;li&gt;Save the policy.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;This tells Supabase to check the logged-in user's unique ID. It will only return rows where that ID matches the &lt;code&gt;user_id&lt;/code&gt; stored in the database.&lt;/p&gt;

&lt;p&gt;You must create separate policies for users to add or modify their data. Create a new policy for the INSERT operation using the exact same &lt;code&gt;auth.uid() = user_id&lt;/code&gt; expression. Repeat this process for the UPDATE operation.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. You disabled RLS to fix a bug
&lt;/h2&gt;

&lt;p&gt;Sometimes developers turn off RLS because a strict database query is failing. If you disabled it to test a feature and left it off, the Security Advisor will flag it.&lt;/p&gt;

&lt;p&gt;If this is a server-side script or a server action taking place outside the browser, you might be trying to access data that the current user does not own.&lt;/p&gt;

&lt;p&gt;If you have server-side code that needs to bypass RLS, never disable RLS on the table itself. Instead, your backend code should use the Supabase &lt;code&gt;service_role&lt;/code&gt; key. This key bypasses all RLS policies automatically.&lt;/p&gt;

&lt;p&gt;The &lt;code&gt;service_role&lt;/code&gt; key must only be used on a secure server environment. It must never be exposed to the browser. Do not put it in variables starting with &lt;code&gt;NEXT_PUBLIC_&lt;/code&gt; or &lt;code&gt;VITE_&lt;/code&gt;. Turn RLS back on for your table immediately, then update your backend scripts to use the service key.&lt;/p&gt;

&lt;h2&gt;
  
  
  Still stuck?
&lt;/h2&gt;

&lt;p&gt;If your app is rejecting valid database requests or exposing data it should not, &lt;a href="https://dev.to/build"&gt;this is the kind of fix I do&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  Why does my app stop showing data when I enable RLS?
&lt;/h3&gt;

&lt;p&gt;Enabling RLS blocks all read and write access to the table by default. You have to create specific policies that explicitly allow your app to read or modify the data.&lt;/p&gt;

&lt;h3&gt;
  
  
  Can I hide my Supabase anon key so I do not need RLS?
&lt;/h3&gt;

&lt;p&gt;You cannot hide client environment variables that start with &lt;code&gt;NEXT_PUBLIC_&lt;/code&gt; or &lt;code&gt;VITE_&lt;/code&gt; because they are bundled into your frontend code. You must use RLS to secure your database against people finding and using this public key.&lt;/p&gt;

&lt;h3&gt;
  
  
  How do I let users edit their own data?
&lt;/h3&gt;

&lt;p&gt;Enable RLS and create an UPDATE policy using the expression &lt;code&gt;auth.uid() = user_id&lt;/code&gt;. This ensures the database only permits changes if the requesting user matches the owner of the row.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/fix-supabase-rls-disabled-warning" rel="noopener noreferrer"&gt;watershowdigital.com/blog/fix-supabase-rls-disabled-warning&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>supabase</category>
      <category>security</category>
      <category>rls</category>
    </item>
    <item>
      <title>What changed in open models and AI agent tools this week</title>
      <dc:creator>WaterShow</dc:creator>
      <pubDate>Sun, 01 Nov 2026 15:38:31 +0000</pubDate>
      <link>https://dev.to/watershow/what-changed-in-open-models-and-ai-agent-tools-this-week-59m2</link>
      <guid>https://dev.to/watershow/what-changed-in-open-models-and-ai-agent-tools-this-week-59m2</guid>
      <description>&lt;p&gt;New open weights and agent tools shipped this week, alongside a security risk in a popular developer extension. &lt;/p&gt;

&lt;p&gt;You get a new coding model to self-host, a way to build chat bots that remember past sessions, an Android agent that clicks buttons for you, and a reason to check your code editor extensions.&lt;/p&gt;

&lt;h2&gt;
  
  
  Mistral Large 4 open weights
&lt;/h2&gt;

&lt;p&gt;Mistral released &lt;a href="https://mistral.ai/news/mistral-large-4-oss/" rel="noopener noreferrer"&gt;Mistral Large 4&lt;/a&gt; as an open weights model. It is a 1-trillion parameter model trained on European infrastructure. The focus of this release is coding and defensive cybersecurity.&lt;/p&gt;

&lt;p&gt;The model supports three reasoning modes. Low mode is for simple tasks. Medium mode handles everyday tasks. High mode is the default and is used for use cases requiring high precision.&lt;/p&gt;

&lt;p&gt;It scores 48 percent on the Artificial Analysis Coding Agent Index. On the Artificial Analysis Cyber Index, it scores 51 percent. This index measures the ability of a model to discover vulnerabilities, reproduce them, and patch them. The model has a refusal rate of 96.6 percent on malicious cyber requests. &lt;/p&gt;

&lt;h2&gt;
  
  
  Persona AI SDK
&lt;/h2&gt;

&lt;p&gt;The &lt;a href="https://github.com/tavern-labs-ai/persona-ai-sdk" rel="noopener noreferrer"&gt;Persona AI SDK&lt;/a&gt; is a TypeScript package for building AI characters that remember past conversations. It separates the persona, memory, model, persistence, and interface into different layers. &lt;/p&gt;

&lt;p&gt;You can store memory in-memory, as atomic JSON files, or in a SQLite database. The SDK includes adapters for OpenAI and Amazon Bedrock. It comes with default personas like atlas, a strategic analyst, and sage, a customer support agent. &lt;/p&gt;

&lt;p&gt;To install the core runtime and adapters, run this command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;npm &lt;span class="nb"&gt;install &lt;/span&gt;persona-ai-sdk
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;If you want to use the SQLite storage adapter, you need to install the native dependency:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;npm &lt;span class="nb"&gt;install &lt;/span&gt;better-sqlite3
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Mika for Android
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://github.com/wangzan101/Mika" rel="noopener noreferrer"&gt;Mika&lt;/a&gt; is an open source on-device AI agent for Android written in Kotlin. It operates apps and websites for you. It runs on a hidden background screen so you can keep using your phone normally. &lt;/p&gt;

&lt;p&gt;Mika looks at the screen and finds buttons visually. It does not rely on specific app APIs. You need to provide your own model API key or sign in with an account from providers like OpenAI or Anthropic.&lt;/p&gt;

&lt;p&gt;The agent defaults to Ask mode. This mode asks for your permission before spending money or placing orders. You can also switch it to Autonomous mode. Mika includes a Linux sandbox for arm64 devices to run Python, Node, and shell commands on files.&lt;/p&gt;

&lt;p&gt;To set up a model, configure it in the app settings. &lt;/p&gt;

&lt;h2&gt;
  
  
  Claude Code extension backdoor
&lt;/h2&gt;

&lt;p&gt;Phorion found a backdoor in the official &lt;a href="https://phorion.io/blog/offical-claude-code-vsx-compromise/" rel="noopener noreferrer"&gt;Claude Code for VS Code extension&lt;/a&gt; distributed on the Cursor Marketplace. The affected versions are 2.1.312 and 2.1.313. Cursor removed these versions from the marketplace.&lt;/p&gt;

&lt;p&gt;The backdoor drops an SSH key appended to the authorized keys file. The key uses the comment &lt;code&gt;svc-telemetry&lt;/code&gt;. It sets up a reverse SSH tunnel to an external server on port 22. The malware uses an embedded private key commented with &lt;code&gt;svc-telemetry-tun&lt;/code&gt; to authenticate to the tunnel server.&lt;/p&gt;

&lt;p&gt;The script establishes persistence using cron jobs on Linux, launch agents on macOS, and scheduled tasks on Windows. It also sends a beacon to the attacker. This beacon includes the hostname, username, public IP address, and up to 40 environment variable names that match keywords for secrets or cloud credentials.&lt;/p&gt;

&lt;p&gt;On macOS, the setup script contains a bug. It runs a check for the remote login status without root privileges. The system prints an error and exits. The script treats this error as confirmation that SSH is already on. It skips the command to enable SSH entirely. &lt;/p&gt;

&lt;h2&gt;
  
  
  The catch
&lt;/h2&gt;

&lt;p&gt;Mistral Large 4 is a 1-trillion parameter model. Running a model of this size requires significant hardware infrastructure. &lt;/p&gt;

&lt;p&gt;The Persona AI SDK provides the building blocks for memory and personas, but horizontally scaled deployments require you to implement your own memory store using a database like PostgreSQL. &lt;/p&gt;

&lt;p&gt;Mika needs Android 11 or later for basic chat and web browsing. Operating phone apps requires Android 12, but Android 14 or later is recommended. Operating third-party apps automatically with Mika may break their terms of service. Password entry pages often block screenshots, so Mika will ask you to take over manual control on those screens.&lt;/p&gt;

&lt;p&gt;For the Claude Code backdoor, the macOS SSH bug breaks the inbound access path if SSH was not already running. The malware still successfully drops the SSH keys, installs persistence, and beacons host reconnaissance data back to the operator. &lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;h3&gt;
  
  
  What reasoning modes does Mistral Large 4 support?
&lt;/h3&gt;

&lt;p&gt;Mistral Large 4 supports Low, Medium, and High reasoning modes. Low mode is for simple tasks, Medium is for everyday tasks, and High is the default for complex use cases.&lt;/p&gt;

&lt;h3&gt;
  
  
  Which versions of the Claude Code extension contain the backdoor?
&lt;/h3&gt;

&lt;p&gt;Versions 2.1.312 and 2.1.313 of the Claude Code for VS Code extension on the Cursor Marketplace contain the backdoor. Cursor has removed these versions. &lt;/p&gt;

&lt;h3&gt;
  
  
  How does Mika interact with Android applications?
&lt;/h3&gt;

&lt;p&gt;Mika looks at the screen and finds buttons visually. It runs on a hidden background screen and does not require specific app APIs.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://watershowdigital.com/blog/ai-updates-mistral-large-4-persona-sdk" rel="noopener noreferrer"&gt;watershowdigital.com/blog/ai-updates-mistral-large-4-persona-sdk&lt;/a&gt;.&lt;/em&gt; Need a hand with your app or automation? &lt;a href="https://watershowdigital.com/build" rel="noopener noreferrer"&gt;WaterShow Digital&lt;/a&gt; fixes and builds it, fixed quote first.&lt;/p&gt;

</description>
      <category>ai</category>
      <category>agents</category>
      <category>llm</category>
      <category>security</category>
    </item>
  </channel>
</rss>
