# Slims V9 Db Structure

> SLiMS 9 Bulian database structure guide for reading, documenting, tracing, and explaining the SQL schema. Use this skill to understand SLiMS v9 table purposes, follow relationships between bibliography, item, member, circulation, master, OPAC search, and admin tables, map SQL fields to library workflows, or explain schema details from the raw SQL.

- **Type:** Skill
- **Install:** `agentstack add skill-prisma-ddti-skills-slims-v9-db-structure`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [prisma-ddti](https://agentstack.voostack.com/s/prisma-ddti)
- **Installs:** 0
- **Category:** [Databases](https://agentstack.voostack.com/c/databases)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [prisma-ddti](https://github.com/prisma-ddti)
- **Source:** https://github.com/prisma-ddti/skills/tree/main/skills/slims-v9-db-structure

## Install

```sh
agentstack add skill-prisma-ddti-skills-slims-v9-db-structure
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# SLiMS v9 DB Structure

## Quick Start

- Confirm the target is SLiMS 9 Bulian.
- Read [references/schema-overview.md](references/schema-overview.md) before writing SQL, documentation, or integration notes.
- Switch to `dspace-v6-db-structure` if the task is about DSpace, not SLiMS.

## Working Rules

- Identify the business area first: catalog, copies, loans, members, settings, search, or admin.
- Find the core table before expanding to bridge and lookup tables (e.g., `biblio_author`, `biblio_topic`, `mst_*`).
- Treat `senayan.sql` as the authoritative baseline.
- Treat table relationships as logical (application-enforced), not database-enforced FK constraints — many tables use `MyISAM`.
- Separate bibliographic records (`biblio` = title/work) from physical copies (`item` = exemplar).
- Decode coded fields via master tables (`mst_*`) instead of guessing their meaning.
- Prefer structural explanation over speculative business logic. If a column purpose is unclear, say so.
- Check denormalized tables (`search_biblio`, `loan_history`) only after understanding the core transaction tables.
- Some fields store serialized values or JSON — note this before proposing direct SQL changes.

## Bundled Resource

- `references/schema-overview.md`: Table families, key fields, relationship map, and storage caveats from the official `senayan.sql`.

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [prisma-ddti](https://github.com/prisma-ddti)
- **Source:** [prisma-ddti/skills](https://github.com/prisma-ddti/skills)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-prisma-ddti-skills-slims-v9-db-structure
- Seller: https://agentstack.voostack.com/s/prisma-ddti
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.