Skip to main content
Resources expose data to MCP clients as readable content identified by URIs. SMKRV MCP Studio supports two types: dynamic (SQL-backed) and static (inline content).

​
Resource Types

​
Dynamic Resources

Dynamic resources execute a SQL query against a database connection and return the results. They use URI templates with parameters: Example URI template: 
/resource/users/{user_id}
Example SQL: 
SELECT id, name, email
FROM users
WHERE id = :user_id

​
Static Resources

Static resources serve fixed inline content without a database connection. Use them for configuration data or reference documents.

​
URI Template Parameters

Parameters in URI templates use {param} syntax and are auto-detected:
URI TemplateDetected Parameters
/resource/users/{user_id}user_id
/resource/orders/{status}/{year}status, year
/resource/config(none)

​
MIME Types

MIME TypeUse Case
application/jsonJSON data (default)
text/plainPlain text
text/csvCSV tabular data
text/htmlHTML content
application/xmlXML data

​
Managing Resources

​
Creating a Resource

  1. Navigate to Resources in the sidebar
  2. Click New Resource
  3. Choose resource type (dynamic or static)
  4. Fill in the URI template and content or SQL query
  5. Configure parameters and MIME type
  6. Select a connection (dynamic only)
  7. Click Save

​
Editing and Deleting

  • Edit: Click a resource card to open the editor
  • Delete: Click the delete icon and confirm

​
See Also

Connections

Create the database connections that dynamic resources query against

Tools

Build SQL-backed tools with typed parameters

Prompts

Design reusable prompt templates

Flow Editor

Manage resources visually on the drag-and-drop canvas

Deployment

Deploy your resources as part of the MCP server

REST API

Resource CRUD endpoints in the REST API