How to Share Postgres Query Results via Public Link

Last updated: November 21, 2025

Share Postgres query results publicly with Indiequery. Create shareable links that display your visualizations (charts and tables) with live data from your database. Anyone with the link can view the data - no login required.

Enable Public Sharing for a Query

All queries and visualizations stay private by default. To share a query result:

  1. Run your query and create a visualization (bar chart, line chart, area chart, or table)
  2. Click Share Publicly on the visualization
  3. Copy the generated link The public link displays your visualization exactly as you configured it. Viewers see the chart type, colors, labels, and data format you set up.

Public links show live data from your database. When someone visits the link, they see the latest query results - not a static snapshot.

If you update the underlying data in your database, viewers see the new data when they refresh the link. You don't need to regenerate the link or manually update anything.

Example: Share a "Weekly Signups" chart. When new users sign up, the public chart automatically reflects the current count without any action from you.

Disable Sharing Anytime

Click Stop Sharing to revoke access to the public link. The link immediately stops working - visitors see an error message instead of your data.

You can re-enable sharing later if needed. Disabling and re-enabling generates a new link (the old link won't work anymore).

Share Different Visualization Types

Each visualization type works with public sharing:

Bar charts - Compare categories:

SELECT product_name, SUM(quantity) as units_sold
FROM order_items
GROUP BY product_name
ORDER BY units_sold DESC
LIMIT 10;

Share as a bar chart showing top products by sales volume.

Line charts - Show trends over time:

SELECT DATE(created_at) as date, COUNT(*) as signups
FROM users
WHERE created_at > NOW() - INTERVAL '30 days'
GROUP BY date
ORDER BY date;

Share as a line chart tracking daily signups.

Area charts - Highlight cumulative metrics:

SELECT
  DATE(created_at) as date,
  subscription_tier,
  COUNT(*) as users
FROM users
GROUP BY date, subscription_tier
ORDER BY date;

Share as a stacked area chart showing subscription growth by tier.

Tables - Display detailed data:

SELECT
  email,
  subscription_tier,
  DATE(created_at) as signup_date,
  monthly_revenue
FROM users
WHERE status = 'active'
ORDER BY monthly_revenue DESC
LIMIT 50;

Share as a formatted table with column sorting and pagination.

Common Sharing Use Cases

Client Dashboards: Share metrics directly with clients without giving them database access. Create visualizations for KPIs they care about and send them the public link.

Team Documentation: Embed live charts in Notion, Confluence, or internal wikis. Your documentation always shows current data without manual updates.

Status Pages: Display uptime, performance metrics, or system health on public status pages. Visitors see real-time data straight from your database.

Investor Updates: Share revenue, user growth, or engagement metrics with investors. They can check the link anytime for the latest numbers.

Marketing Pages: Add live customer count, testimonial stats, or product usage metrics to your marketing site. Social proof that updates automatically.

Security and Privacy

No database credentials exposed: Public links only show query results, never connection details or credentials.

Read-only access: Viewers can't modify data, run different queries, or access other parts of your database.

Unique tokens: Each public link uses a unique token. Links can't be guessed or enumerated.

Revocable instantly: Disable sharing to immediately stop access. The link breaks right away.

No login required: Anyone with the link can view the data. Don't share links to sensitive data publicly - only share what you want everyone to see.

Update Shared Visualizations

When you modify the query SQL or visualization settings (change colors, adjust chart type, update column formatting), the public link reflects those changes immediately.

Edit once, update everywhere. This applies to:

  • Query SQL changes
  • Chart type (switch from bar to line)
  • Color schemes
  • Column labels and formatting
  • Table pagination settings

Refresh Frequency

Public links show data from the last query execution. To update the data:

  1. Open the query in Indiequery
  2. Click Run Query
  3. The public link now shows the new results Or set up automatic refresh by running queries on a schedule (future feature). For now, manually re-run queries when you want to update public data.

Share Multiple Queries

You can create public links for as many queries as you need. Each link is independent:

  • Different queries get different links
  • Disable one without affecting others
  • Each link shows only its specific query results Build a collection of shareable metrics by creating multiple queries and enabling public sharing on each one.

Public links work on mobile devices. Charts and tables adapt to smaller screens so viewers on phones and tablets see readable visualizations.

The public link is a standard URL. Share it via:

  • Email
  • Slack or Teams messages
  • Embed in web pages with <iframe>
  • Add to documentation or wikis
  • Include in presentations Anyone who receives the link can access it - no Indiequery account needed.

What Viewers See

When someone opens your public link, they see:

  • The visualization (chart or table) you configured
  • Current data from your database (as of last query run)
  • No Indiequery branding or navigation
  • No ability to edit or run different queries It's a clean, focused view of just that one visualization.

View all your public shared visualizations in one place. Click Shared Links to see:

  • Which queries are publicly shared
  • When each link was created
  • Quick disable buttons for each link This central view makes it easy to audit what you're sharing and revoke access if needed.
← Back to Indiequery Integration